Version of SQLite used in Android?

by

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 (tip: just stick a breakpoint in your Activity onCreate() and use this code in Evaluate Expression...):

val version = android.database.sqlite.SQLiteDatabase.create(null).use {
    android.database.DatabaseUtils.stringForQuery(it, "SELECT sqlite_version()", null)
}
"Framework (API ${android.os.Build.VERSION.SDK_INT}) SQLite version: $version".also { println(it) }

Using the emulators (note, SQLite version on actual devices will be at least that specified):

API level* Version Name SQLite Notes
32 12L ? 3.32.2
31 12 S 3.32.2
30 11 R 3.28.0 window functions
29 10 Q 3.22.0
28 9 Pie 3.22.0
27 8.1 Oreo 3.19.4 see 3.19.3 and version control check-ins because 3.19.4 link does not exist
26 8.0 Oreo 3.18.2 O beta versions used 3.18.0
25 7.1.1 Nougat 3.9.2
24 7.0 Nougat 3.9.2
23 6.0 Marshmallow 3.8.10.2 M Preview 1 (SDK level 22) used 3.8.10
22 5.1.1 Lollipop 3.8.6.1 see 3.8.6 and version control check-ins because 3.8.6.1 link does not exist
21 5.0 Lollipop 3.8.6
20 4.4W.2 Android Wear unknown no emulator available, but probably either 3.7.11 or 3.8.4.3
19 4.4 KitKat 3.7.11
18 4.3 Jelly Bean 3.7.11
17 4.2 Jelly Bean 3.7.11
16** 4.1 Jelly Bean 3.7.11
15 4.0.3 Ice Cream Sandwich 3.7.4
14** 4.0 Ice Cream Sandwich 3.7.4
13 3.2 Honeycomb 3.7.4
12 3.1 Honeycomb 3.7.4
11** 3.0 Honeycomb 3.7.4
10 2.3.3 Gingerbread 3.6.22
9 2.3.1 Gingerbread 3.6.22
8** 2.2 Froyo 3.6.22
7 2.1 Eclair 3.5.9
4 1.6 Donut 3.5.9
3** 1.5 Cupcake 3.5.9

* 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).

More Related Contents:

  1. Convert SQLITE SQL dump file to POSTGRESQL
  2. Android: Where are database files stored?
  3. Can I download an SQLite db on /sdcard and access it from my Android app?
  4. Populate Android Database From CSV file?
  5. Populating Spinner From SQLite Database Android
  6. Android SQLite data display to ListView
  7. Pros and Cons of SQLite and Shared Preferences [closed]
  8. How do I view the SQLite database on an Android device? [duplicate]
  9. Best way to work with dates in Android SQLite [closed]
  10. How do I backup a database file to the SD card on Android?
  11. Copying data from one SQLite database to another
  12. Best place to close database connection
  13. What’s the difference between a catalog and a schema in a relational database?
  14. How to retrieve the last autoincremented ID from a SQLite table?
  15. Import .csv file to Sqlite in Android
  16. Cursor adapter and sqlite example [closed]
  17. How to retrieve data from sqlite database in android and display it in TextView
  18. SQLite insert speed slows as number of records increases due to an index
  19. Android: Cannot perform this operation because the connection pool has been closed
  20. SQLite simultaneous reading and writing
  21. update sql database with ContentValues and the update-method
  22. Android multiple databases open
  23. What’s the best way to migrate a Django DB from SQLite to MySQL?
  24. Create SQLite database in android
  25. Limit an sqlite Table’s Maximum Number of Rows
  26. Saving ArrayLists in SQLite databases
  27. SQLite android column not found
  28. How to store JSON object in SQLite database
  29. Predict next auto-inserted row id (SQLite)
  30. SQLiteOpenHelper onUpgrade() Confusion Android

Leave a Comment