SQLite

3.2.6

Released on 17 Sep 2005
Project description.

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format.

SQLite 3.2.6 Changelog
  • Fix a bug that can cause database corruption if a VACUUM (or autovacuum) fails and is rolled back on a database that is larger than 1GiB
  • LIKE optimization now works for columns with COLLATE NOCASE
  • ORDER BY and GROUP BY now use bounded memory
  • Added support for COUNT(DISTINCT expr)
  • Change the way SUM() handles NULL values in order to comply with the SQL standard
  • Use fdatasync() instead of fsync() where possible in order to speed up commits slightly
  • Use of the CROSS keyword in a join turns off the table reordering optimization
  • Added the experimental and undocumented EXPLAIN QUERY PLAN capability
  • Use the unicode API in Windows