Open sqlite in readonly directly from assets

Question

I've found a lot of solutions to about how its possible to copy a database from assets to /data/data/tld.c.u/databases/ - But is it absolutely impossible to just open the database in readonly and query its content?

I have a rather large database i'm distributing with the app and its kind of a waste if the database must be copied out of the assets folder.

This may help: http://stackoverflow.com/a/9109728/265167 – Yaqub Ahmad Mar 29 '12 at 07:55 — Yaqub Ahmad, Mar 29 '12 at 07:55

score 3 · Accepted Answer · answered Mar 28 '12 at 15:57

3

But is it absolutely impossible to just open the database in readonly and query its content?

Yes.

I have a rather large database i'm distributing with the app and its kind of a waste if the database must be copied out of the assets folder.

Consider not distributing it with the app, but rather downloading it on first run, or using Google Play's new APK expansion files facility.

answered Mar 28 '12 at 15:57

CommonsWare

986,068
189
2,389
2,491

2

WHY is it not possible? Just because the Android API doesn't expose the correct methods? Or an actual design decision? – SystemParadox Mar 13 '13 at 21:37
5

@SystemParadox: Because SQLite needs a file. – CommonsWare Mar 13 '13 at 22:11

Open sqlite in readonly directly from assets

1 Answers1

Linked

Related