SQLite 3.7.0 Released!!

모처럼만에 SQLite 가 업데이트 되었다. 이번에 업데이트를 진행하면서 부터인지 웹페이지도 분위기도 로고도 좀 바뀌었다.

SQLite 3.7.0 버전에서 바뀐 사항.

• 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().

SQLite 홈페이지

SQLite Release Note