how to browse SQLite database

Common bugs/problems with the Android SDK the Emulator and the ADT-Plugin.

how to browse SQLite database

Postby soclose » Sun May 02, 2010 5:34 am

Hi

I use Eclipse 3.5.2 and android-sdk_r05-windows package. I develop an android 1.6 project in it. I could create a new sqlite database and table, insert, update and delete it. Here, I don't know how to browse sqlite database. I mean in mysql, we could browse it in command prompt and in ms sql, browse it from Management Studio. In SQLite, how to? Thank you.
soclose
Experienced Developer
Experienced Developer
 
Posts: 80
Joined: Sun Apr 25, 2010 8:38 am

Top

Re: how to browse SQLite database

Postby daijobu » Fri May 28, 2010 4:43 am

I use SQLite Manager plug-in on FireFox. I usually pull that database from emulator or device, and open it by SQLite Manager.
daijobu
Freshman
Freshman
 
Posts: 2
Joined: Mon Aug 10, 2009 7:55 am

Re: how to browse SQLite database

Postby Mafiozo » Wed Jun 09, 2010 6:33 pm

You have a plugin called Questoid Sqllite manager, it is a plugin for Eclipse. Add it to program and then in ddms you can open your database and view it. It's by far easiest way to view it.
Mafiozo
Freshman
Freshman
 
Posts: 8
Joined: Mon May 24, 2010 8:29 pm

Re: how to browse SQLite database

Postby vengeance_mj » Fri Jun 11, 2010 5:50 am

if you want the hard way go to command prompt
then type in the following I'm assuming that your package is anddev.android

Code: Select all
adb -s emulator-5554 shell
          #sqlite3 /data/data/anddev.android/<databaseName>.db
vengeance_mj
Senior Developer
Senior Developer
 
Posts: 174
Joined: Thu Oct 29, 2009 2:32 am

Top

Return to SDK/ADT/Emulator Problems

Who is online

Users browsing this forum: No registered users and 3 guests