SQLite versions 2.8.16 and 3.1.2 are now available from the website, http://www.sqlite.org/
This release fixes a bug in the VACUUM command that can cause database corruption. It is recommended that all users upgrade. The bug that was fixed has been present in all prior versions of SQLite that supported VACUUM, but it is difficult to hit so it has taken until now to be noticed. Additional information is available at http://www.sqlite.org/cvstrac/tktview?tn=1116 Version 3.1.2 is also (by coincidence) the first stable release of the 3.1 line. SQLite 3.1 adds support for correlated subqueries, autovacuum, autoincrement, ALTER TABLE, and other features. Please let me know if you find any problems with either release. -- D. Richard Hipp <[EMAIL PROTECTED]>