Sqlite db in assets folder

Question

There is problem in understanding the concept.

I am creating a SQLite sample app in android. currently i am using the path /data/data/packname/databases to store the database.

and there is nothing in my assets folder, i want to know how can i copy the database from my internal path in to assets folder.

Reason:- I want to see database files onupgrade().

I found lots of question related that but not satisfied with the answers .

Any Suggestions

wsanville · Answer 1 · 2013-03-14T15:13:19.020

2

You can't copy anything into your assets folder inside your APK, because APKs can't be changed at runtime.

To do the opposite, that is, package a database in you assets folder and write it to disk, you can use this project: https://github.com/jgilfelt/android-sqlite-asset-helper You use this at development time, not runtime though.

edited Mar 14 '13 at 15:13

answered Mar 14 '13 at 04:37

wsanville

37,158
8
76
101

Then how can i put my db file in assets. – Monty Mar 14 '13 at 05:02

score 0 · Answer 2 · answered Mar 14 '13 at 05:23

0

You can copy data base from assets folder to your emulator or device at run time. If you want to see your updated data base you have to fetch data base from emulator to your system from

data/data/packagename/databases

I think it is not possible to change data at run time in assets folder. I tried to do that but not success-ed in that. If you found solution post it, so that i can use it.

answered Mar 14 '13 at 05:23

Manoj Fegde

4,786
15
50
95

what you want ,you are giving ans or asking the question. – Monty Mar 14 '13 at 06:52

score 0 · Answer 3 · edited May 23 '17 at 12:30

What i have understanding from your question is your little misconception with how can see SQLite database, so if you have to see your database file then you do not need to save your database in your assets folder.Database file is in the data>data>your application package>database. You can push file from your device and see it. So if you have to see your database then please follow my answer of this question. Where i have briefly describe how can you see you database.

Sqlite db in assets folder

3 Answers3

Linked