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
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.
sqlite-users mailing list