Small. Fast. Reliable.
Choose any three.

SQLite Release 3.6.19 On 2009-10-14

  1. Added support for foreign key constraints. Foreign key constraints are disabled by default. Use the foreign_keys pragma to turn them on.
  2. Generalized the IS and IS NOT operators to take arbitrary expressions on their right-hand side.
  3. The TCL Interface has been enhanced to use the Non-Recursive Engine (NRE) interface to the TCL interpreter when linked against TCL 8.6 or later.
  4. Fix a bug introduced in 3.6.18 that can lead to a segfault when an attempt is made to write on a read-only database.

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.