What is the version of SQLite used in Android?
Reason: I'm wondering how to handle schema migrations. The newer SQLite versions support an "ALTER TABLE" SQL command which would save me having to copy data, drop the table, recreate table and re-insert data.
Best Answer
Here is a link to the official docs which include the main points in this answer: android.database.sqlite package-level javadoc
Kotlin code to get framework SQLite version:
Using the emulators (note, SQLite version on actual devices will be at least that specified):
* Android API level links show where the android.database.sqlite package has changed. Where there is no link (e.g. API level 17), indicates no changes to that package.
** Broken SDK link, see here
Note: if you want your app to use the same version of SQLite across all Android versions, consider using Requery's 3rd party SQLite support library or SQLCipher (if you also want encryption).