There is a software which can be embedded into Eclipse which called Questoid SQLite Browser
Here are the steps of the configuration:
- Download the Questoid Plugin
- Place the file in your Eclipse plugins folder (e.g. /usr/lib/eclipse/plugins)
- Restart Eclipse
- Start up an Android Emulator w/ Debugging in Eclipse
- Switch to the DDMS Perspective in Eclipse
- Go to the ‘File Explorer’ tab to locate your device’s database file
- Navigate to: e.g. ‘data -> data -> com.myproject -> databases -> myproject
- Open the database file in Questoid (see screen shot)
- Switch to the ‘Questoid SQLite Browser’ tab that appears (mine appears next to LogCat by default)
- Switch to the ‘Browse Data’ sub tab
- Select your table from the drop down menu
- Browse your data here
Does the Questoid Pluginallows you to modify and save data without pulling the database file from phone?
Unfortunately it doesn’t has write function. If you need to modify the date, you need another software.
Anyway which software do you use for modify the data?
I’m extracting the database file through DDMS perspective, and modify with SQLite Database Browser. Then push it back.