*** DRAFT ***

SQLite Release 3.1.0 On 2005-01-21

  1. Autovacuum support added
  2. CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP added
  3. Support for the EXISTS clause added.
  4. Support for correlated subqueries added.
  5. Added the ESCAPE clause on the LIKE operator.
  6. Support for ALTER TABLE ... RENAME TABLE ... added
  7. AUTOINCREMENT keyword supported on INTEGER PRIMARY KEY
  8. Many SQLITE_OMIT_ macros inserts to omit features at compile-time and reduce the library footprint.
  9. The REINDEX command was added.
  10. The engine no longer consults the main table if it can get all the information it needs from an index.
  11. Many nuisance bugs 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 ***