SQLite 3.6.18 Released!!

SQLite가 한달 만에 업데이트가 되었다.

사이트 에서는 이전 버전 3.6.12 이전 버전의 사용자는 업그레이드를 추천하고있다.

이번 버전에서 수정된 사항은 아래와 같다.
SQLite Release 3.6.18 On 2009 Sep 11 (3.6.18)

• 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-Preprocessor macro SQLITE_SOURCE_ID, C/C++ interface sqlite3_sourceid(), and SQL function sqlite_source_id().
• Obscure bug fix on triggers ([efc02f9779]).