Small. Fast. Reliable.
Choose any three.
Search for:

## 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.