How to use prepeared SQLite database in android app?

Question

I have quite large SQLite database (around 80.000 lines), and i whant to use it in my application. So the question is: how to implement this? I found solution:

adding file.db into project/assets folder
write my own SQLiteOpenHelper

is enought for that purpose? will it work fine with such large ammount of records?

[This answer][1] might be useful in work with assets database. [1]: stackoverflow.com/questions/9109438/… — yurezcv
– yurezcv, Commented Nov 12, 2013 at 14:41

CommonsWare · Accepted Answer · 2013-11-12 14:39:31Z

1

Use SQLiteAssetHelper. There are instructions for packaging the database (ZIP file inside of assets/). Then you extend SQLiteAssetHelper instead of SQLiteOpenHelper. It will handle unpacking the database for you.

The number of database "lines" does not matter. However, bear in mind that an APK cannot be over 50MB without running into problems (e.g., cannot distribute via the Play Store).

answered Nov 12, 2013 at 14:39

CommonsWare

1.0m195 gold badges2.4k silver badges2.7k bronze badges

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

Collectives™ on Stack Overflow

How to use prepeared SQLite database in android app?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related