I am a little bit confused about the sqlite db version numbers.
1. On Windows 7 I have created a new db with command
The sqlite3.exe is from date 2013-05-20 and the version number shows 3.7.17
2. Same computer but now I create a db with sqlite3.exe from 2016-09-12
The version number now shows 3.14.2
3. I open both db (test.db3 and test1.db3) with sqlitestudio 3.0.6 and do a:
Now for both dbs the version number shows 3.8.10
So from what depends the version number? From the tool or program
which opens the db?
If I create a new db like in step 2 where I have version 3.14.2 and I
open it with an old
tool or program, then I cannot use the newer functions and fixes of
the new version?
Can someone please give me a little bit clearness?
sqlite-users mailing list