Search code examples
androidsqliteintellij-ideaadb

inspecting android sqlite and IntelliJ

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?

Solution

  • 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)