I have a database that is 5 MB. Where should I place this database? I tried putting database in Assets folder and then
copy it to data/data/com.example.android/databases folder using following code

Code: Select all

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();

    }


Problem is if Database is 2 MB or greater. It exceeds the size and throws an exception. Is there an example online regarding where to place prepopulated big databases? Any help is highly apprecaited.

I followed following tutorial for copying database in case someone is interested.

http://www.reigndesign.com/blog/using-y ... lications/

Is your database a .csv file? Then you can probably import everything into a table by using sqlite console. Correct me if I understood u incorrectly

No my database is not a CVS file. I created database with SQLite browser and pre-populated data in tables. Pardon my ignorance, but I think SQLite doesn't create CVS file. right?

I haven't tried this, but apparently you are on the right track

http://www.reigndesign.com/blog/using-y ... lications/

Following link explains that Android has limitation on Files of size > 1MB
I was hoping if I could bypass chopping my DB into multiple files.

http://www.chriskopec.com/blog/2010/mar ... databases/

If the database is too large, you could place the database on a server somewhere and access it remotely. Of course the issues with this are requiring the Full Internet Access Permission, and, of course, having to rely on data connections to access the database.

But who knows, maybe this will be just fine for you.

Good Luck
-Nick

well could you store the values with which you populated the tables in the database in the [comma seperated file] .csv file . Since even I had the same problem while trying to use WeatherBug API which required cityCodes and trying to do a lookup for a cityCode on the net was making the app go slow.
I got all the values they had in a .csv file and just imported that in databases package using sqlite console.
Hope that helps

My application is sort of ebook. So creating CVS is kind of hard as line feeds lead database to think start of a new record

okay here is what I have done. I took my database file and using hjsplit utility split it in 500K files. Placed them in Assets folder and on run time created a DB

myInput = myContext.getAssets().open("db1");
while ((length = myInput.read(buffer))>0){
if(Constants.Debug){Log.d("CopyDataBase", "writing database");}
myOutput.write(buffer, 0, length);
myOutput.flush();
if(Constants.Debug){Log.d("CopyDataBase", "copied first file");}
}

and so on for other files.

I hate development and love it at the same time

Nice.. thank you for putting that up. I'm sure I'll run into that eventually

I hate development and love it at the same time

Word.