Android dev: Sync database

Question

This is my first time writing an Android app that utilizes a database.

I have created a test database in the assets folder. I then have the app copy the database to the database folder: /data/data/myapplication1/databases/myDB.db

I realize now that the assets folders are read only, but how can I sync my database so I can verify, using SQLite browser, the changes I have made?

Should I just move my test DB from assets to a different location? Is there something better?

Or is there a way I can view the DB in the databases folder? (which I believe is protected so it is not visible to other programs)

ahmedre · Accepted Answer · 2015-09-29 22:00:55Z

2

to view the database from the databases folder:

with adb on either a rooted device or an emulator, just adb pull /data/data/myapplication/databases/mydb.db.
with adb on a non-rooted/non-emulator, you can try adb shell "run-as [package.name.myapplication] cp /data/data/myapplication/databases/mydb.db /sdcard/mydb.db", and then adb pull /sdcard/mydb.db.
if you integrate stetho in your app, you can easily inspect sqlite databases from chrome.

answered Sep 29, 2015 at 22:00

ahmedre

1,7241 gold badge15 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Android dev: Sync database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related