How to insert existing DataBase in Android Project

Question

I would like to insert an existing SQLite database into my Android project.

In other words, I do not want to create it, but just to be able to access it within my app.

How would I be able to access the database, and in which folder should I put it?

Put in assets folder in your app. check this - http://stackoverflow.com/questions/9109438/how-to-use-an-existing-database-with-an-android-application — Wasim K. Memon, May 10 '16 at 10:03

score 1 · Answer 1 · answered May 10 '16 at 10:01

1

You have to add it into asset folder and reference it back in helper class

answered May 10 '16 at 10:01

Haroon

497
4
13

score 1 · Accepted Answer · edited Aug 22 '18 at 12:48

1

Well, it's pretty easy, just put your database.db in assets folder and you can use Android SQLiteAssetHelper to read and write the database, this library makes the process pretty easy and straightforward.

Import the library

compile 'com.readystatesoftware.sqliteasset:sqliteassethelper:+'

and then

public class MyDatabase extends SQLiteAssetHelper {

private static final String DATABASE_NAME = "northwind.db";
private static final int DATABASE_VERSION = 1;

public MyDatabase(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);

}

That's all you need to do to access the database.

Here is the full example for your convenience.

edited Aug 22 '18 at 12:48

halfer

19,824
17
99
186

answered May 10 '16 at 10:28

Atiq

14,435
6
54
69

Thank you! If I decide to use SQLiteAssetHelper will I also be able to write on the DB ? – Thomas May 11 '16 at 11:01
yup ofc, you can use `getWritableDatabase()` with asset helper to write any values to database – Atiq May 11 '16 at 11:04

score 0 · Answer 3 · answered May 10 '16 at 10:20

Put Your Data Base In Asset Folder

  public void CopyDataBaseFromAsset() throws IOException {
    InputStream in  = context.getAssets().open(DATABASE_NAME);
    Log.e("sample", "Starting copying");
    String outputFileName = DATABASE_PATH+DATABASE_NAME;
    File databaseFile = new File( "/data/data/*YOUR PACKGE NAME*/databases");
    // check if databases folder exists, if not create one and its subfolders
    if (!databaseFile.exists()){
        databaseFile.mkdir();
    }

    OutputStream out = new FileOutputStream(outputFileName);

    byte[] buffer = new byte[1024];
    int length;


    while ((length = in.read(buffer))>0){
        out.write(buffer,0,length);
    }
    Log.e("sample", "Completed" );
    out.flush();
    out.close();
    in.close();

}

How to insert existing DataBase in Android Project

3 Answers3