Pre-Fill SQLite database with initial data before runtime

Question

I created an android application and everything works fine. It uses SQLite database into which after calling the onCreate method values are inserted and later requested.

In my opinion it is a waste of performance if i fill it whenever the onCreate is called. When i deliver the application to a user I would like to give this prefilled database(it will not change any more), so that

it is not refilled whenever onCreate is called
it is not necessary any more to have data - which should be inserted - hardcodedcin my code

Is there any possiblity to do this, or is my only option to fill it during runtime?

score 1 · Answer 1 · answered Jun 09 '17 at 10:46

1

Try this guide: Using your own SQLite database in Android applications

answered Jun 09 '17 at 10:46

Aman Khalid

91
9

1

This is more like a comment, not an answar – S.R Jun 09 '17 at 18:31

score 1 · Accepted Answer · answered Jun 09 '17 at 10:57

In my opinion it is a waste of performance if i fill it whenever the onCreate is called

Normally, onCreate() on a SQLiteOpenHelper is called once per app installation. More directly, onCreate() is only called if the database needs to be created, because the database does not already exist. So, "out of the box", "it is not refilled whenever onCreate is called".

When i deliver the application to a user I would like to give this prefilled database(it will not change any more)

Use SQLiteAssetHelper.

Pre-Fill SQLite database with initial data before runtime

2 Answers2