SQLite Release 3.6.0 On 2008-07-16

• Modifications to the virtual file system interface to support a wider range of embedded systems. See 35to36.html for additional information. *** Potentially incompatible change ***
• All C-preprocessor macros used to control compile-time options now begin with the prefix "SQLITE_". This may require changes to applications that compile SQLite using their own makefiles and with custom compile-time options, hence we mark this as a *** Potentially incompatible change ***
• The SQLITE_MUTEX_APPDEF compile-time option is no longer supported. Alternative mutex implementations can now be added at run-time using the sqlite3_config() interface with the SQLITE_CONFIG_MUTEX verb. *** Potentially incompatible change ***
• The handling of IN and NOT IN operators that contain a NULL on their right-hand side expression is brought into compliance with the SQL standard and with other SQL database engines. This is a bug fix, but as it has the potential to break legacy applications that depend on the older buggy behavior, we mark that as a *** Potentially incompatible change ***
• The result column names generated for compound subqueries have been simplified to show only the name of the column of the original table and omit the table name. This makes SQLite operate more like other SQL database engines.
• Added the sqlite3_config() interface for doing run-time configuration of the entire SQLite library.
• Added the sqlite3_status() interface used for querying run-time status information about the overall SQLite library and its subsystems.
• Added the sqlite3_initialize() and sqlite3_shutdown() interfaces.
• The SQLITE_OPEN_NOMUTEX option was added to sqlite3_open_v2().
• Added the PRAGMA page_count command.
• Added the sqlite3_next_stmt() interface.
• Added a new R*Tree virtual table

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