On May 12, 2008, at 12:00 PM, Scott Baker wrote: > > What's the advantage to making all new DBs created format 4? I'm > against > breaking backwards compatibility.
Please reread the post carefully. This is *not* a backwards compatibility break. Format 4 provides DESC index capability and a tighter encoding for boolean values. Every version of SQLite released over the past 2 years can read and write both format 4 and format 1 without any problems. However, if you create a new database in format 4 and then try to read it using a version of SQLite that is more than 2 years old, the older SQLite will be unable to read the file and will return an error. Note that on older systems this should not be a problem since databases will be both created and read by older versions of SQLite. Note that for upgrading this should not be a problem since older database will continue to be readable and writable by newer versions of SQLite. The only time this will cause a problem is when you create a new database file using SQLite 3.6.0 or later and then try to read or write that file using a different version of SQLite that is more than 2 years old. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users