Changes and additions:

• added connection pooling support to PostgreSQL back end;
• changed audit transaction timestamps to SRFI 19 time-utcs;
• added query-logger parameter;
• added sql-list syntax.

Changes and additions:

• updated from SQLite.plt v3.x to SQLite.plt v4.3.

Changes and additions:

• simplified the query system:
  • the macro query language is now the preferred way of writing queries;
  • entity names can now be used in queries;
  • introduced entity.attr syntax to refer to attributes;
  • special attribute aliases are no longer required;
• simplified accessing entity/attribute metadata:
  • the entity name foo can now be used instead of entity:foo;
  • the syntax (attr entity attr-id) has been added to replace attr:entity-attr-id;
• enhancements to the quick-find system:
  • quick-find procedures now accept #:what, #:order, #:limit and #:offset arguments;
• documented the #:ssl option for PostgreSQL in the Quick Start, including a note about the lower speed of SSL-enabled connections;
• removed extraneous provides from snooze.ss.

Changes:

• argumentless and and or are supported;
• added extra functions to the check library;
• added extra information to persistent-struct-info, supporting simple development of more advanced persistent struct related macros.

Changes:

• corrected typos in the quick start in the docs;
• updated the contract on the make-database procedure for the SQLite backend, to match changes in the contract on the open procedure in sqlite.plt.

Fixes to documentation compilation bugs.

Fixes to documentation compilation bugs.

New features:

• added a struct-saved? procedure as the preferred method of checking whether a struct has been saved to the database.

Bug fixes:

• joins are rendered in a manner that is acceptable to SQLite;
• #:distinct works correctly in the syntax query language;
• sql:string-append and sql:string-replace have the correct names.

New features:

• a completely new procedural query language that supports nested subqueries, expressions on columns, aggregate functions and DISTINCT, GROUP and HAVING clauses;
• a new syntax wrapper for the query language, allowing briefer queries;
• full support for nested transactions in PostgreSQL (including rollback of persistent structs to keep them synced with changes in the database);
• an experimental audit trail feature (warning: the interface is likely to change in a future release).
• persistent-structs are now serializable with scheme/serialize.

Known issues:

• transaction support and pipelines have not been fully documented;
• a bug in SQLite causes all queries with nested joins in them to fail: a solution to this problem is being worked on.

• more Scribble documentation;
• fixes to the rendering of "IN" and "CROSS JOIN" statements.

The PostgreSQL backend now uses SPGSQL 2.1.