Sqlite plugin for Eclipse: debug sqlite database on Android device live

android database sqlite debugging live
AZ_ picture AZ_ · May 6, 2011 · Viewed 30.8k times · Source

I want to debug database on android device. My application is very heavy and I do too much insertion queries and other stuff so running on emulator is hell slow so I am debugging it on Android phone.

But I could not debug database, like in Iphone you can see even insertion made into database. I want to see the current situation of database without rooting my phone and pulling it from my phone and then opening it into some 3rd party software.

Is there any way to debug Android database on mobile phones without rooting and pulling database out?

There is tool sqlite3 but the problem is that when you connect to shell it shows you ugly data and furthermore if database is not created running any query actually creates database in database folder so you would never knew that your database was not created by your logic.

I hope you understand what I am looking for.

Answer

jrmgx picture jrmgx · Nov 8, 2011

I had the very same problem and after a search I found this one SQLiteManager plugin for Eclipse which is a plugin for eclipse allowing you to see and browse your data strait from SQLite DB

To use this it's easy, start you emulator, browse the emulator files in the DDMS view then go to data > data > com.your.package > databases > your_database_name.db (note the db extension is mandatory) and a new tab will appear with your data! It won't work on a real device (maybe on a rooted one?)

Hope it will work for you :)

Related questions

How do I view the SQLite database on an Android device?

I have a set of data in an SQLite database. I need to view the database on a device. How do I do that? I have checked in ddms mode. The data in file explorer is empty.

Read More
What are the best practices for SQLite on Android?

What would be considered the best practices when executing queries on an SQLite database within an Android app? Is it safe to run inserts, deletes and select queries from an AsyncTask's doInBackground? Or should I use the UI Thread? I …

Read More
Best way to work with dates in Android SQLite

I'm having some trouble working with dates on my Android application that uses SQLite. I have a couple questions: What type should I use to store dates in SQLite (text, integer, ...)? Given the best way to store dates how do …

Read More