Attach a pre-exising SQLite database in Android

Question

I have a SQLite database that I already created and it has data in it.

Now I just want to attach the database with existing tables and keys without any changes to the Android application and use it.

Most of the samples about SQLite databases in Android involve creating the database in the application, like this link. But my database file already exists.

After some searching, I found this link about database attachment but it isn't clear and I don't understand where I should put the database file and how to call the attachment query for it.

Use `SQLiteAssetHelper`: https://github.com/jgilfelt/android-sqlite-asset-helper — CommonsWare, Jun 24 '14 at 20:08

score 1 · Accepted Answer · answered Jun 24 '14 at 20:35

1

Just use sqllite asset helper

It's the best lib out there that serves your purpouse. I also wrote a blogpost about preloading sqllite data (and other stuff) here

answered Jun 24 '14 at 20:35

fedepaol

6,834
3
27
34

bhowden · Answer 2 · 2014-06-24T20:18:05.210

0

String path = "/path/to/database/file";
SQLiteDatabase database = SQLiteDatabase.openDatabase(path, null, 0);

edited Jun 24 '14 at 20:18

answered Jun 24 '14 at 20:09

bhowden

669
7
15

Attach a pre-exising SQLite database in Android

2 Answers2