On 11 Oct 2016, at 9:52am, Werner Kleiner <sqlitetes...@gmail.com> wrote:
> I am a little bit confused about the sqlite db version numbers. The version numbers you are seeing reported are not the version of the database file. All those databases are in the format for SQLite version 3. Instead the version numbers reported are the version of SQLite compiled into the program you're using to find out the version number. SQLite is not a library or service stored on a central place on your computer. Each program which uses SQLite has SQLite compiled into it. So you can have six different programs on your computer, and they can each implement slightly different versions of SQLite. And that would be fine because no significant changes to the SQLite file format have been made for years. As long as they are all contain version 3.0 or above of the source code, they can all read and write each-other's version 3.0 file format. There are some features which have been introduced since version 3 file format was created. For instance, in August 2013 partial indexes were introduced in SQLite version 3.8.0. But if a particular database file does not use partial indexes, then even if it was created with a version later than that date, it can still be read and written using a version earlier than that date. Hope this helps. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users