2

Does anyone know of Android code I could embed directly in my app, such that I could browse my SQLite database directly from within my app?

If not, how about code that reads the SQLite metadata, and dumps table and column names and data to the log? (In JDBC, I'd use databasemetadata to get table info, and then table metadata to get column info...)

I know I can browse on an emulator, and I can copy the db off the device and then point a db browser at it. But this would be a lot more convenient for me during development. This would of course be used only for test databases with tiny amounts of data. Any suggestions?

Oak Bytes
  • 4,649
  • 4
  • 36
  • 53
Brian FTG
  • 23
  • 3

2 Answers2

1

Have a look at this question: browse data in Android SQLite Database It may not be exactly what you're asking, but may be sufficient for your needs.

Alternatively, there's a sqlite database browser app in the market, which you may be interested in (I haven't tested it myself): https://market.android.com/details?id=com.xuecs.sqlitemanager&hl=en

Community
  • 1
  • 1
Aleks G
  • 56,435
  • 29
  • 168
  • 265
  • Thanks for the quick response. But I'm finding emulators are way too slow, and I can't see the data (by security design) in my usb-connected XOOM. I'm a newbie, so I don't want to root. Given all that, I'm still looking for a chunk of code that will dump all column name and values given a table name, and also a chunk of code that will give me all table names in my db. (I'm trying to write it now. Just a little bit lazy...) – Brian FTG Feb 17 '12 at 14:17
0

I think this is what you are looking for .

Using the library in the link below you can browse your app database from your app https://github.com/sanathp/DatabaseManager_For_Android

With this library you can manage your app SQLite database from you app itself. you can view the tables in your app database , update ,delete, insert rows to your tables .Everything from your app.

Its a single java activity file ,just add the java file to your source folder.When the development is done remove the java file from your src folder thats it .

It helped me a lot .Hope it helps you too .

You can view the 1 minute demo here : http://youtu.be/P5vpaGoBlBY

sanath_p
  • 2,198
  • 2
  • 26
  • 22