thank you. Best Martin ________________________________ Von: Jay A. Kreibich <j...@kreibi.ch> An: General Discussion of SQLite Database <sqlite-users@sqlite.org> Gesendet: Mittwoch, den 1. April 2009, 15:52:08 Uhr Betreff: Re: [sqlite] Binary Format
On Wed, Apr 01, 2009 at 08:24:29AM +0000, Martin Pfeifle scratched on the wall: > Hi, > we do use SQLite in a standardisation initiative and have to?state > which?binary?file-format of sqlite is used. > Up to now, I was of the opinion that all sqlite versions 3.x use the same > binary sqlite file > format but only differ in the library functionality. > Can somebody confirm that the binary disk format does not change in 3.x or > can it change and > we have to say, we use the binary format of sqlite 3.5.4 for instance, or is > it enough to say > that we use 3.x as binary file format? There are two SQLite3 file formats: v1 and v4. Version 4 supports descending indexes and a more compact Boolean storage format. v4 support was originally added in version 3.3.0 and was used as the default file format for a very short time. As of 3.3.7, things went back to using the v1 format by default. As far as I know, that's still true all the way up to the current 3.6.12 release. All SQLite3 versions can read/write v1. Everything after 3.3.0 can read/write v1 and v4. Versions prior to 3.3 cannot read/write v4. The command "PRAGMA legacy_file_format = [ON|OFF]" can be used to force the use of the v1 file format. It's default value is defined by the SQLITE_DEFAULT_FILE_FORMAT compile time option, which currently defaults to ON/v1. That is, by default current builds of SQLite3 use the v1 file format (although they still support both versions). The SQLite development team has indicated a desire to change this default, although nothing as been said about an expected timeline. Generally the larger issue with library versions is the SQL used within the database. If you use a specific language feature in a table, index, or view definition, then you're obviously limiting the file to a specific version of the SQLite library, even if the file format is technically version compatible with earlier versions. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
