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

Reply via email to