Use a pre-populated sqllite db file with Room

Asked Dec 27 '17 at 10:32

Active Dec 27 '17 at 12:06

Viewed 245 times

Is there a way to use a pre-populated sqlite db file like "xyz.db" with Android Room. I went through couple of posts but still not able to figure out a robust solution.

The db file "xyx.db" is located in the assets/databases folder.

Also I want to know if Android Room is the right choice for an app which uses DB only for read. There would be no writes to the DB. Please suggest any alternate approach to solve this kind of problem with an ORM solution.

edited Dec 27 '17 at 11:02

Phantômaxx

37,901
21
84
115

asked Dec 27 '17 at 10:32

Ved Agarwal

https://github.com/jgilfelt/android-sqlite-asset-helper – pskink Dec 27 '17 at 10:35
I am looking for a better solution. – Ved Agarwal Dec 27 '17 at 10:53
Looking for some out of the box solution provided by Room. Maybe through the migration route. – Ved Agarwal Dec 27 '17 at 10:56
`RoomDatabase.Builder#openHelperFactory` is out of the box solution – pskink Dec 27 '17 at 11:00
2

I also had same question. Take a look at Commonware's solution here, https://github.com/commonsguy/cw-androidarch/tree/v0.6/General/AssetRoom . No need to copy the db file. – live-love Jan 01 '18 at 17:12

Use a pre-populated sqllite db file with Room

0 Answers0