久违了，SQLite 3.7.0

 

久违了，SQLite 3.7.0

 

    SQLite 3.7.0版本终于发布了，就在今天，2010年7月22号。久违了，这是里程碑性的一个版本，从日志上看从19号到22号都在进行发布前的各种调整，更直观的是换了一个崭新可爱的Logo。这是从3.6.23直接跳跃的版本。主要的变更内容，如下：

 

SQLite Release 3.7.0 On 2010 July 22 (3.7.0)

Changes associated with this release include the following:

• Added support for write-ahead logging .
• Query planner enhancement - automatic transient indices are created when doing so reduces the estimated query time.
• Query planner enhancement - the ORDER BY becomes a no-op if the query also contains a GROUP BY clause that forces the correct output order.
• Add the SQLITE_DBSTATUS_CACHE_USED verb for sqlite3_db_status() .
• The logical database size is now stored in the database header so that bytes can be appended to the end of the database file without corrupting it and so that SQLite will work correctly on systems that lack support for ftruncate().

更多的信息，请访问官网：http://www.sqlite.org/