Small. Fast. Reliable.
Choose any three.
SQLite Release 3.2.6 On 2005 September 17 (3.2.6)
- 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
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.