android using sqlite as a static data

Question

Possible Duplicate:
Android pre-filled DB

I want to use SQLite as a static data. By that I mean to preload it with data before application first start. This data is static = no inserts, deletes or updates. I just want to use full power of sql database queries and indexes. Because my SQLite database should have a lot a lot of data I don't want to upset users with long initial loading time.

Is there any way to do it (preloaded, predefined, preinserted database)?

Is there any way to create `.db` file and put it in assets folder and just load it on initial start? — zmeda, Jun 10 '11 at 07:42
Take a look at http://stackoverflow.com/questions/5051889/android-pre-filled-db — Ben Williams, Jun 10 '11 at 07:46

score 2 · Answer 1 · answered Jun 10 '11 at 07:49

No, sadly this is not possible. A workaround is to copy the database over to the application data or to the SD card (if available) and load it from there, but IMHO this is an ugly solution.

Have you thought about using Java data structures for this data? It should be much faster to preload. If you do not want to use plain Java structures, I would recommend to use JSON or protobuf - whatever works best for you. :-)

android using sqlite as a static data

1 Answers1