How can I browse the SQLite database that I am creating in my app on my Android myTouch phone?
When I log in through adb shell, sqlite3 gives me a permission denied. Is there another way to check if my database and tables are actually being created, and if rows are being inserted?
I am not able to use the emulator, since it doesn't play videos etc. very well that is the main feature of my app, so I can only test on phone.
Android SQLite is a very lightweight database which comes with Android OS. Android SQLite combines a clean SQL interface with a very small memory footprint and decent speed. For Android, SQLite is “baked into” the Android runtime, so every Android application can create its own SQLite databases.
The entire database is a single file, so via the DDMS view in Eclipse or via the command line you can pull that file from the phone. You can then use SQLite DataBase Browser to view the contents, for example.
Using this library you can browse your SQLite database directly from your application https://github.com/sanathp/DatabaseManager_For_Android
Its a single java activity file ,just add the java file to your source folder you can view the tables in your app database , update ,delete, insert rows to you table .Everything from your app.
When the development is done remove the java file from your src folder thats it .
It helped me a lot .Hope it helps you too .
You can view the 1 minute demo here : http://youtu.be/P5vpaGoBlBY
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With