How to view data saved in android database(SQLite)?

by

You can access this folder using the DDMS for your Emulator. you can’t access this location on a real device unless you have a rooted device.

You can view Table structure and Data in Eclipse. Here are the steps

  1. Install SqliteManagerPlugin for Eclipse. Jump to step 5 if you already have it.
  2. Download the *.jar file from here
  3. Put the *.jar file into the folder eclipse/dropins/
  4. Restart eclipse
  5. In the top right of eclipse, click the DDMS icon
  6. Select the proper emulator in the left panel
  7. In the File Explorer tab on the main panel, go to /data/data/[YOUR.APP.NAMESPACE]/databases
  8. Underneath the DDMS icon, there should be a new blue icon of a Database light up when you select your database. Click it and you will see a Questoid Sqlite Manager tab open up to view your data.

*Note: If the database doesn’t light up, it may be because your database doesn’t have a *.db file extension. Be sure your database is called [DATABASE_NAME].db

*Note: if you want to use a DB without .db-Extension:

  1. Download this Questoid SqLiteBrowser: http://www.java2s.com/Code/JarDownload/com.questoid/com.questoid.sqlitebrowser_1.2.0.jar.zip

  2. Unzip and put it into eclipse/dropins (not Plugins)

Check this for more information

More Related Contents:

  1. get Feature item to list View
  2. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  3. How to store image in SQLite database
  4. How do I use prepared statements in SQlite in Android?
  5. Where does Android emulator store SQLite database?
  6. Android SQLite Example [closed]
  7. Android database encryption
  8. Android SQLite issue – table … has no column named
  9. How to add new Column to Android SQLite Database?
  10. Android error – close() was never explicitly called on database
  11. Exporting SQLite Database to csv file in android
  12. What is a maximum size of SQLite database on Android?
  13. How to save images into Database
  14. Full text search example in Android
  15. How to get Last record from Sqlite?
  16. rawQuery(query, selectionArgs)
  17. select distinct value in android sqlite
  18. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  19. A pre-populated database does not work at API 28 throws “no such table” exception
  20. How does one check if a table exists in an Android SQLite database?
  21. how to save image taken from camera and show it to listview – crashes with “IllegalStateException”
  22. When should I do certain SQLite operations on another thread(not the main thread)?
  23. Changing values from Cursor using SimpleCursorAdapter
  24. SQLite exception: Database is locked issue
  25. How can I reset a autoincrement sequence number in sqlite
  26. Sqlite issues with HTC Desire HD
  27. SQLiteOpenHelper – creating database on SD card
  28. How to store JSON object in SQLite database
  29. Android SQLiteOpenHelper cannot open database file
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment