Using Preloaded Sqlite Database in Android

Question

I want to use pre-loaded sqlite database which is as big as 250 Megabytes. I have copied the database into assets folder. Since we can not access the assets database directly, I am copying the database from assets into "context.getFilesDir()" folder.
Using this strategy my app works well for small database up to 5-6 megabytes but app crashes if I do so for large database, which is what I want.

Is there any better way or something wrong with what I am trying to do? I have already tried solutions of the possible copies Android: Accessing assets folder sqlite database file with .sqlite extension Getting a column from .sqlite containing multiple tables with multiple columns How to use preloaded SQLite database in Android from Assets

My code for SqliteHelper is given below for reference.

package com.example.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQueryBuilder;
import android.util.Log;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.Locale;

/**
 * Created by MOHIT on 06-08-2014.
 */
public class SQLiteHelper  {
    private static final String DB_NAME = "alldb.sqlite";
    //private String DB_NAME = "alldb.sqlite";

    private Context context;
    private SQLiteDatabase database;
    public SQLiteHelper(Context context) {
        this.context = context;
    }

    public SQLiteDatabase openDatabase() {
        File dbFile = new File(context.getFilesDir(), DB_NAME);

        if (!dbFile.exists()) {
            try {
                copyDatabase(dbFile);
            } catch (IOException e) {
           //     Utilities.makeToastLong(context, "Error here");
                throw new RuntimeException("Error creating source database", e);

            }
        }

        database= SQLiteDatabase.openDatabase(dbFile.getPath(), null, SQLiteDatabase.OPEN_READONLY);

        return database;

    }
    public void closeDatabase()
    {
        if(database!=null&& database.isOpen())
          database.close();
    }

    private void copyDatabase(File dbFile) throws IOException {

        try {

            InputStream is = context.getAssets().open(DB_NAME);
            dbFile.createNewFile();
            OutputStream os = new FileOutputStream(dbFile,false);

            byte[] buffer = new byte[1024];
            while (is.read(buffer) > 0) {
                os.write(buffer);
            }

            os.flush();
            os.close();
            is.close();
        }catch (Exception e)
        {
            Log.e(SQLiteHelper.class.getSimpleName()," Error in Database copy "+e.getLocalizedMessage());

        }
    }
}

@DIVA yes it is crashing with SQLiteDatabaseCorruptException developer.android.com/reference/android/database/sqlite/… — eternal_developer
– eternal_developer, Commented Aug 27, 2014 at 4:49
i guess there is issue in copying..is it woking for small size db? hv u done any upgrade recently on db? — KOTIOS
– KOTIOS, Commented Aug 27, 2014 at 4:54
No upgrades on Db and yes its working excellent for small size DB. — eternal_developer
– eternal_developer, Commented Aug 27, 2014 at 5:00

113408 · Accepted Answer · 2014-08-27 04:41:55Z

0

I read in a lot of other topics that the size limit for the pre-loaded SQLite DB is 50Megabytes. To bypass this limit you can:

1-Copy the DB to external folder

2-From external folder, you copy the DB to your internalStorage /data/data/yourApp

3-check at start up if the DB exists, if not copy it

Limitation on Google Blog . You may need to use the Expansion File for your DB

edited Aug 27, 2014 at 4:41

answered Aug 27, 2014 at 4:33

113408

3,4446 gold badges31 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

eternal_developer Over a year ago

What kind of external folder? I am using assets folder.

113408 Over a year ago

You cannot use the assets folder to store your DB. see my edit

Martín Alcubierre · Accepted Answer · 2014-08-27 05:08:14Z

0

This this code, through org.apache.commons.io.IOUtils.

public static void initialize(Context context) {
    File dbFile = getDatabaseAbsolutePath(context);
    if (!dbFile.exists()) {
        if (Ln.isDebugEnabled()) Ln.i("###### Copying preloaded DATABASE to: "+dbFile.getAbsolutePath());
        InputStream is = null;
        FileOutputStream fos = null;
        try {
            is = context.getAssets().open("init.db");
            fos = new FileOutputStream(dbFile);
            IOUtils.copy(is, fos);
        } catch (Exception e) {
            if ( Ln.isDebugEnabled()) e.printStackTrace();
        } finally {
            try {
                if (is != null) is.close();
                if (fos != null) fos.close();
            } catch(Exception e) {}
        }
    }
}

answered Aug 27, 2014 at 5:08

Martín Alcubierre

4,3972 gold badges30 silver badges28 bronze badges

2 Comments

Martín Alcubierre Over a year ago

BTW, Ln is log library from roboguice. You can change is with your favorite logging.

Martín Alcubierre Over a year ago

I have init.db in assets path.

Collectives™ on Stack Overflow

Using Preloaded Sqlite Database in Android

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related