Getting version of Sqlite database

Question

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

Answer 1

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

Answer 2

I think you can do it with openhelper, check here https://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html