How to find version of sql light database used in android
Below is android API version for corresponding SQL Light Version
SQLite 3.7.11:
- 17-4.2-Jelly Bean
- 16-4.1-Jelly Bean
SQLite 3.7.4:
- 15-4.0.3-Ice Cream Sandwich
- 14-4.0-Ice Cream Sandwich
- 13-3.2-Honeycomb
- 12-3.1-Honeycomb
- 11-3.0-Honeycomb
SQLite 3.6.22:
- 10-2.3.3-Gingerbread
- 9-2.3.1-Gingerbread
- 8-2.2-Froyo
SQLite 3.5.9:
- 7-2.1-Eclair
- 4-1.6-Donut
- 3-1.5-Cupcake
There are also several other SQLite versions out there (list by no means exhaustive):
** UPDATE: Android Complete tutorial now available here.
SQLite 3.7.6.3:
- LG Optimus Sol E730/myTouch E739/myTouch Q C800 (10-2.3.3-Gingerbread, GRJ22)
- LG Optimus Vu F100S (10-2.3.3-Gingerbread, RK39F)
- LG Optimus LTE TAG F120K/F120L (10-2.3.3-Gingerbread, GRK39F)
- LG Optimus LTE L-01D (10-2.3.3-Gingerbread, GRJ90)
- LG Optimus Net P690b (10-2.3.3-Gingerbread, GINGERBREAD)
- LG Prada KU5400 (10-2.3.3-Gingerbread, GWK74)
- LG Prada P940 (10-2.3.3-Gingerbread, GWK74)
- LG LU6200/SU640 (10-2.3.3-Gingerbread, GRJ90)
SQLite 3.7.0.1:
- LG Esteem MS910 (10-2.3.3-Gingerbread, GSE-_v.05)
- AndroTab (8-2.2-Froyo, 1.0.7100.0385)
- GPLUS MUSN M500 (8-2.2-Froyo, FRG83G)
SQLite 3.6.23.1:
- Motorola Backflip MB300 (7-2.1-Eclair, ERD79)
- Garmin-Asus n¼vifone A10/A50/Garminfone (7-2.1-Eclair, ERE27)
Android SDK level links show where the android.database.sqlite package has changed. Where there is no link (e.g. SDK level 17), indicates no changes to that package.adb command to get SQLite version only works on emulators and on devices with sqlite3 available:
Programatically finding SQL database Version:
Cursor cursor = SQLiteDatabase.openOrCreateDatabase(":memory:", null).rawQuery("select sqlite_version() AS sqlite_version", null);
String sqliteVersion = "";
while(cursor.moveToNext()){
sqliteVersion += cursor.getString(0);
}
