> You can convert a V1 database into a V4 database by opening it, > setting the legacy PRAGMA to false, and the VACUUMing the database. > You can convert back in a similar way. In fact, be cautious of that. > If you have a build that defaults to V1, make sure you turn the > legacy PRAGMA off before you VACUUM a V4 database, or it will convert > it back to V1 (I think...). > > http://www.sqlite.org/compile.html#default_file_format > http://www.sqlite.org/pragma.html#pragma_legacy_file_format
If this is true, the documentation doesn't even hint at the feature: "This flag only affects newly created databases. It has no effect on databases that already exist." I would test it, but "When the pragma is issued with no argument, it returns the setting of the flag. This pragma does not tell which file format the current database is using. It tells what format will be used by any newly created databases." One way to test it would be to try opening an up-converted database in a version previous to 3.3.0, which I don't have handy. RW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
