Geek Answers Handbook

Android browses SQLite database on phone

How can I view the SQLite database that I create in my application on my myTouch Android phone?

When I log in through adb shell, sqlite3 gives me permission to refuse. Is there any other way to check if my database and tables are really created, and if rows are inserted?

I can not use the emulator, as it does not play video, etc. very good, which is the main feature of my application, so I can only test on the phone.

+6
android database sqlite android-sqlite
source share
2 answers

The whole database is a single file, therefore, through the DDMS view in Eclipse or through the command line, you can pull this file from the phone. You can then use SQLite DataBase Browser to view the content, for example.

+4
source share

Using this library, you can view the SQLite database directly from the application https://github.com/sanathp/DatabaseManager_For_Android

Its the only java activity file, just add the java file to the source folder, you can view the tables in the application database, update, delete, insert rows in the table. Everything from your application.

When development is complete, delete the java file from your src folder.

It helped me a lot. Hope this helps too.

You can watch the 1 minute demo here: http://youtu.be/P5vpaGoBlBY

0
source share

More articles:


All Articles