Android prefilled DB

Question

Is it possible to supply prefilled SQLite DB to my app? I want to use db as ordinary SQLite db which will have tables filled manually and I want to include it into my .apk file.

Will the SQLite database be used read-only or will you app add data to it? — Robert, Feb 19 '11 at 16:37
refer the link https://stackoverflow.com/questions/513084/ship-an-application-with-a-database — Shyju M, Sep 27 '17 at 11:42
Refer the link https://stackoverflow.com/questions/513084/ship-an-application-with-a-database — Shyju M, Sep 27 '17 at 11:45

score 3 · Accepted Answer · answered Feb 19 '11 at 16:36

3

Yes, include it in your assets folder and copy it into the /databases folder when your application first launches.

answered Feb 19 '11 at 16:36

smith324

13,020
9
37
58

So, I place my db in /assets folder and then...? Could you please explain it? – Feb 19 '11 at 16:38
See my comment here. http://stackoverflow.com/questions/4753896/externally-generated-sqlite-database-considered-read-only-by-androids-sqliteopen/4753927#4753927 – Nick Campion Feb 19 '11 at 17:35

score 3 · Answer 2 · edited Jun 30 '14 at 15:16

3

try this

private void copyDataBase() throws IOException{

    //Open your local db as the input stream
    InputStream myInput = myContext.getAssets().open(DB_NAME);

    // Path to the just created empty db
    String outFileName = DB_PATH + DB_NAME;

    //Open the empty db as the output stream
    OutputStream myOutput = new FileOutputStream(outFileName);

    //transfer bytes from the inputfile to the outputfile
    byte[] buffer = new byte[1024];
    int length;
    while ((length = myInput.read(buffer))>0){
        myOutput.write(buffer, 0, length);
    }

    //Close the streams
    myOutput.flush();
    myOutput.close();
    myInput.close();

}

edited Jun 30 '14 at 15:16

Phantômaxx

37,901
21
84
115

answered Feb 19 '11 at 16:39

Rohit Mandiwal

10,258
5
70
83

I keep receiving FileNotFound exception when app attempts to open OutputStream. In fact, on first start there is no /database/ dir and app fails to create it. – Feb 21 '11 at 18:35
Fixed that, it's necessary to create both dir and file explicitly, thnx to all! – Feb 21 '11 at 18:57
The previous code is the correct solution. I've done this on one of my application, you can find more information here : http://androidblogger.blogspot.com/2009/05/how-to-ship-application-with-pre-baked.html But finally I decided to stop using this technique, as it implies the database is present twice in your application ( once in the asset folder, once in your application folder ), and for a big database that can be problematic. – alocaly Feb 20 '11 at 02:53
How should I treat journal file? Should I add to assets and copy it as well? – János Sep 21 '16 at 13:51

score 0 · Answer 3 · answered Jan 13 '16 at 06:01

0

Including in the assets folder is one option (Apk size will be increased.)

How about storing the pre-filled db on any cloud storage service provider and downloading the file on the first run of the app?

answered Jan 13 '16 at 06:01

Shree Harsha S

665
7
14

Android prefilled DB

3 Answers3

Linked

Related