On Feb 18, 2009, at 10:00 PM, Jay A. Kreibich wrote: > On Wed, Feb 18, 2009 at 05:33:50PM -0500, Igor Tandetnik scratched > on the wall: >> jose isaias cabrera <cabr...@wrc.xerox.com> >> wrote: >>> Greetings and salutations. >>> >>> Can one SQLite db be UPDATEd and used by folks using different DLL >>> versions? >> >> All 3.* versions use the same file format, and can happily coexist. > > Not exactly. The file format changed with 3.3.0. Files made with > 3.3.0 and later cannot be read by earlier 3.x versions. Older files > can be read by newer versions, however. That was over three years > ago, however.
Version 3.0.0 will read and write database files created with all later versions of SQLite provided that the database file does not contain features that were added after 3.0.0. For example, the CURRENT_DATE keyword was added in 3.1.0. So if your schema contains a default value of CURRENT_DATE, it won't be readable by 3.0.8 or earlier. For another example, the INDEXED BY clause was added in version 3.6.4. If your schema contains a view that uses INDEXED BY, then your database will not be readable by 3.6.3 or earlier. Version 3.3.0 introduced support for descending indices. Descending indices are turned off by default, for backwards compatibility. You have to enable them using PRAGMA legacy_file_format=OFF. Assuming you leave descending indices turned off, a database file created by 3.6.11 should be readable and writable by 3.0.0. Versions 3.3.0 through 3.3.6 had descending indices turned on by default. Version 3.3.7 through the current have descending indices turned off for compatibility. (Versions 3.3.0 through 3.3.6 created a lot of problems - we learned our lession.) Note, however, that I am itching to turn descending indices on by default. As soon as it seems like all pre-3.3.0 versions of SQLite have been upgraded, I will probably do so. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
