*** DRAFT ***

SQLite Release 3.6.12 On 2009-03-31

  1. Fixed a bug that caused database corruption when an incremental_vacuum is rolled back in an in-memory database. Ticket #3761.
  2. Added the sqlite3_unlock_notify() interface.
  3. Added the reverse_unordered_selects pragma.
  4. The default page size on windows is automatically adjusted to match the capabilities of the underlying filesystem.
  5. Add the new ".genfkey" command in the CLI for generating triggers to implement foreign key constraints.
  6. Performance improvements for "count(*)" queries.
  7. Reduce the amount of heap memory used, especially by TRIGGERs.

A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.

*** DRAFT ***