How to find SQLITE database file version

Question

I have few sqlite database files. I want to know the database file version i.e if the database was created with sqlite2 or sqlite3 or any other main/sub version (not the sqlite library or driver or user_version or schema_version).

Answer 1

You can extract the information from the header file. It will require you to open the database file 'by hand' but I don't know if there is an API function to get this information.

Answer 2

You have to open the python shell then write these steps:

import sqlite3

sqlite3.sqlite_version

Answer 3

I found this to be the easiest method to determine the version of sqlite. Run the Python IDLE Shell, then do the following:

>>> import sqlite3
>>> sqlite3.version
'2.6.0'

In my case it was 2.6.0. Hope this helps... Mark