3 ms·
The version is stored in byte 96 of the header of the sqlite file[1]. I haven't looked but there will be some sqlite command to query it and I'm sure some view
by lbutler 6y ago
The version is stored in byte 96 of the header of the sqlite file[1].
I haven't looked but there will be some sqlite command to query it and I'm sure some viewer tools will display it as well.
[1] https://www.sqlite.org/fileformat.html https://www.sqlite.org/fileformat.html
- pjscott 6y agoYou can print the version with this magical incantation: $ python -c 'import sys, struct; print(struct.unpack(">I", open(sys.argv[1], "rb").read()[96:100])[0])' foo.db