SQLite Release 3.6.18 On 2009 Sep 11 (3.6.18)

Changes associated with this release include the following:

• Versioning of the SQLite source code has transitioned from CVS to Fossil.
• Query planner enhancements
• The SQLITE_ENABLE_STAT2 compile-time option causes the ANALYZE command to collect a small histogram of each index, to help SQLite better select among competing range query indices.
• Recursive triggers can be enabled using the PRAGMA recursive_triggers statement.
• Delete triggers fire when rows are removed due to a REPLACE conflict resolution. This feature is only enabled when recursive triggers are enabled.
• Added the SQLITE_OPEN_SHAREDCACHE and SQLITE_OPEN_PRIVATECACHE flags for sqlite3_open_v2() used to override the global shared cache mode settings for individual database connections.
• Added improved version identification features: C-Preprocess macro SQLITE_SOURCE_ID, C/C++ interface sqlite3_sourceid(), and SQL function sqlite_source_id().
• Obscure bug fix on triggers ([efc02f9779]).

A complete list of SQLite releases in a single pages is also available. A detailed history of every check-in is available at http://www.sqlite.org/src/timeline.