SyntaxFix

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

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

Examples related to android

• Under what circumstances can I call findViewById with an Options Menu / Action Bar item? • How to implement a simple scenario the OO way • My eclipse won't open, i download the bundle pack it keeps saying error log • getting " (1) no such column: _id10 " error • java doesn't run if structure inside of onclick listener • Cannot retrieve string(s) from preferences (settings) • strange error in my Animation Drawable • how to put image in a bundle and pass it to another activity • FragmentActivity to Fragment • A failure occurred while executing com.android.build.gradle.internal.tasks

Examples related to sqlite

• getting " (1) no such column: _id10 " error • Laravel: PDOException: could not find driver • auto create database in Entity Framework Core • How to open .SQLite files • Accessing an SQLite Database in Swift • When does SQLiteOpenHelper onCreate() / onUpgrade() run? • Attempt to write a readonly database - Django w/ SELinux error • Android sqlite how to check if a record exists • How can I add the sqlite3 module to Python? • "Insert if not exists" statement in SQLite