Is there an SQLite database viewer tool in Eclipse?

Question

I am using Eclipse for Android programming. Is there a tool for view an SQLite database in the emulator?

Answer 1

Follow the below steps:

1. Download the .jar file

2. Place the plugin .jar file in your Eclipse plugins folder (e.g. /usr/lib/eclipse/plugins)

3. Restart Eclipse

4. Start up an Android Emulator with debugging in Eclipse

5. Switch to the DDMS Perspective in Eclipse

6. Go to the 'File Explorer' tab to locate your device's database file

7. Navigate to: e.g. 'data -> data -> com.myproject -> databases -> myproject

8. Open the database file in Questoid (see screenshot)

9. Switch to the 'Questoid SQLite Browser' tab that appears (mine appears next to LogCat by default)

10. Switch to the 'Browse Data' sub tab Select your table from the drop down menu Browse your data here and onward into the digital sunset

Refer link

Answer 2

See blog post Browse an Android Emulator SQLite Database in Eclipse.

Answer 3

follow below way -

1. download SQLITE MANAGER JAR .
2. put the jar file into your eclipse/dropins/ folder.

if(ubuntu user)

you can find your dropins folder at usr/share/eclipse/dropins if you don't have permission to paste file at location then opent your terminal (ctrl+alt+T) and type command sudo nautilus then press enter the new window will open then you can paste the jar at the dropins folder

3. now restart the eclipse
4. go to DDMS
5. go to file explorer
6. browse your database file at data -> data -> com.myproject -> databases -> myproject.db
7. then you will se a database manager icon at to of file explorer
8. by clicking this you can see all of your data tables.

to know more follow LINK

Thanks.

Answer 4

Eclipse Plugin for Sqllite