How to access the database when developing on a phone?

Question

I am having trouble accessing the database while I am developing on the phone. Whenever I execute

cd /data/data/com.mycompck/databases

then if I try to run ls I get opendir failed, Permission denied

Or whenever I type in: sqlite3 I get sqlite3: permission denied

What I am doing wrong?

Are there some applications that can help me getting a human view of content resolvers values and/or SQLite databases?

Answer 1

To answer the first part of your question, check out this answer. Basically, your phone needs to have root access, and you need to run adb in root mode (using "adb root").

As for the second part, I use SQLite Database Browser to view my SQLite dbs (though that's only when the db is on my computer; don't know of any on-device browsers). I don't know of any way to get a human view of content resolvers.

Answer 2

You have to be root to access any database file. So, you can either get root on your phone (look for information on Google) or debugging the database just from the emulator (wich gives you root access always).

Bye!