[EMAIL PROTECTED] wrote: > Nikki Locke <[EMAIL PROTECTED]> wrote: > > > 3.2.2 will refuse to read a database file created by 3.3.5 > unless version 3.3.5 was compiled with -DSQLITE_DEFAULT_FILE_FORMAT=1 > or the "PRAGMA legacy_file_format=ON" pragma is used prior to creating > the database. But if the database is created in a way that 3.2.2 > can read it, there should be no incompatibilities between 3.3.5 > and 3.2.2 (or any other SQLite version, for that matter). Anything > created by version 3.2.2 should always be readable by 3.3.5, regardless. > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > >
I have recently updated my development branch from v 3.2.1 to v 3.3.5 and noticed the compatibility issue as well. What are the key differences between the two file formats? Is there a compelling reason to move to the new format (vs using the pragma and keeping the old format)?