CODEWITHSUNDEEP
androidsqlitemigrationschema
Eno
Eno

Reputation: 10860

Version of SQLite used in Android

What version of SQLite is used in Android?

I'm wondering how to handle schema migrations. The newer SQLite versions support an ALTER TABLE SQL command which save me from having to copy data, drop the table, recreate table and re-insert data.

Upvotes: 310

Views: 115969

Answers (5)

Mark
Mark

Reputation: 7718

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
35 15 V 3.44.3 see 3.44.2 and version control check-ins because 3.44.3 link does not exist
34 14 U 3.39.2 RIGHT and FULL OUTER JOIN
33 13 T 3.32.2
32 12L Sv2 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).

Upvotes: 542

Petterson
Petterson

Reputation: 851

A short overview of the Andorid APIs and the supported SQLite versions.

enter image description here

The overview is from the link in Mark's answer.

Upvotes: 7

yanchenko
yanchenko

Reputation: 57176

$ adb shell sqlite3 --version 
3.5.9

Same on ADP1 1.6 & 2.1 emulator.

Upvotes: 25

Juri
Juri

Reputation: 32910

Although the documentation gives 3.4.0 as reference number, if you execute the following sql, you'll notice that there is a much higher number of SQlite installed:

Cursor cursor = SQLiteDatabase.create(null).rawQuery("select sqlite_version() AS sqlite_version", null);
String sqliteVersion = "";
while(cursor.moveToNext()){
   sqliteVersion += cursor.getString(0);
}

This is just a piece of quick, dirty code to retrieve the sqlite version. For instance on a HTC Hero with Android 2.1, I get: 3.5.9.

On my Nexus One with Android 2.2, I even get 3.6.22.

Upvotes: 60

Roar Grønmo
Roar Grønmo

Reputation: 3966

In Room you can query

SELECT sqlite_version()

RG

Upvotes: 4

Related Questions