inspecting android sqlite and IntelliJ

Question

I'm starting out with a small app using programmatically created sqlite db. Is there a way to inspect that db when the app is running on emulator?

Answer 1

You can download the database file from the device to your PC and then use any SQLite browser / tool to inspect the database.

Either via the adb commandline tool from the Android SDK tools

adb pull /data/data/your.app.package.here/databases/yourdatabasefile.db

or via the device browser (File Explorer) in Eclipse in the DDMS perpective (maybe that exists in IntelliJ too, Idk)

or the new Android SDK tools provide a neat standalone version of that DDMS perspective & the file explorer via the new Device Monitor tool (android-sdk/tools/monitor.bat)

Answer 2

This is now possible with IntelliJ IDEA 14:

https://www.jetbrains.com/idea/help/accessing-android-sqlite-databases-from-intellij-idea.html