top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Android SQLite: How to retrieve the all the data's from record from sqlite database and see in ddms?

+1 vote
156 views
Android SQLite: How to retrieve the all the data's from record from sqlite database and see in ddms?
posted Aug 14, 2014 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Step 1
With Eclipse open and your emulator running
select the DDMS perspective by clicking on the Window -> Open Perspective -> DDMS menu option.

Image 1

Step 2
Select the emulator you have currently have running.
Click the File Explorer tab
Find the data folder.

Image 2

Step 3
Follow the filepath to the application you want /data/data/your.app.namespace/dbname.db
Click the Pull a file from the device button and save the database file on your computer.

Image 3

Step 4
Open the SQLite Database Viewer and click Open Database.
Open the file and you can browse the data and view the schema!

Image 4

Credit: http://blog.kwyps.com/2011/07/how-to-view-sqlite-database-on-your.html

answer Aug 14, 2014 by Pardeep Kohli
Similar Questions
+2 votes

I am using SQLite through either Python 2.5 or 2.7, which is the sqlite3 module. In a desktop application, every now and then, and in a fairly irreproducible way, when committing to the database I get this error:

"sqlite3.OperationalError: SQL logic error or missing database"

I thought this was a PySqlite generated error, but now I see the same error is seen with Ruby, PHP, C++ and other languages, so now I think it is generated by SQLite itself...but I really don't know.

If I try additional commits in that same instance of my app being open, it gives me the same error every time. If I close the app and re-open it, it does not give me this error, with the same or very similar data
being written in the same routines. So I "know" that the code as written is correct (a significant--greater than 90%?--of the time I don't see this error).

In terms of what is causing this, I don't know. But I've noticed that on the occasions that this has happened my computer's RAM was pretty bogged down and my computer is pretty laggy. That said, I've had other times when my RAM was hogged just as much and it didn't do this.

This error might go away if I used a newer/cleaner/more RAM computer, but I want to "stress test" my application for those who may be using similarly clunky computers--I want to try to avoid it even for older
model computers.

+1 vote

I want to check specified table contains value or its empty. I used number of complex method to find but no luck, any body can help me.

+2 votes

I need to take a dump file from the database SQLite. Can you suggest me how to take a dump?

Is it similar to MySQL dump?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...