Small. Fast. Reliable.
Choose any three.

SQLite Release 3.6.4 On 2008-10-15

  1. Add option support for LIMIT and ORDER BY clauses on DELETE and UPDATE statements. Only works if SQLite is compiled with SQLITE_ENABLE_UPDATE_DELETE_LIMIT.
  2. Added the sqlite3_stmt_status() interface for performance monitoring.
  3. Add the INDEXED BY clause.
  4. The LOCKING_STYLE extension is now enabled by default on Mac OS X
  5. Added the TRUNCATE option to PRAGMA journal_mode
  6. Performance enhancements to tree balancing logic in the B-Tree layer.
  7. Added the source code and documentation for the genfkey program for automatically generating triggers to enforce foreign key constraints.
  8. Added the SQLITE_OMIT_TRUNCATE_OPTIMIZATION compile-time option.
  9. The SQL language documentation is converted to use syntax diagrams instead of BNF.
  10. Other minor bug fixes

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.