javasqlitesqlitejdbc

Getting version of Sqlite database

I am using the sqliteJDBC library (SqliteDriver) in my Java desktop application to hook to my sqlite database.

Is there a way I can get the version of the database? This way I can know if I need to add missing tables based on the current database version

Thank you

PS: I am coming from android world where you can get the current version and "upgrade database". So I am assuming the database version is embedded in the db file/schema somewhere and can be queried

Thanks

Solution

  • In the Android framework, the database version is just the value set with PRAGMA user_version.