*** DRAFT ***

SQLite Release 3.7.4 On 2010-12-07

  1. Added the sqlite3_blob_reopen() interface to allow an existing sqlite3_blob object to be rebound to a new row.
  2. Use the new sqlite3_blob_reopen() interface to improve the performance of FTS.
  3. VFSes that do not support shared memory are allowed to access WAL databases if PRAGMA locking_mode is set to EXCLUSIVE.
  4. Enhancements to EXPLAIN QUERY PLAN.
  5. Added the sqlite3_stmt_readonly() interface.
  6. Added PRAGMA checkpoint_fullfsync.
  7. Added the SQLITE_FCNTL_FILE_POINTER option to sqlite3_file_control().
  8. Added support for FTS4 and enhancements to the FTS matchinfo() function.
  9. Added the test_superlock.c module which provides example code for obtaining an exclusive lock to a rollback or WAL database.
  10. Added the test_multiplex.c module which provides an example VFS that provides multiplexing (sharding) of a DB, splitting it over multiple files of fixed size.
  11. A very obscure bug associated with the or optimization was fixed.

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 ***