Thanks Steve. This feature is very useful for debugging complicated DB issues. The GitHub page is linking to the source code (which is nice) but should provide a ready-made jar. I was able to find it at http://android-sqlite-browser-for-eclipse.googlecode.com/svn/wiki/HowTo.wiki. Works great.
IntelliJ's Ultimate IDE has this feature but it didn't quite work for me... wasted too much time with random bugs that were clearly not tested before shipping (things like missing IntelliJ cache directories that their plugin tries to load up... or that the plugin keeps overriding whatever package name / db name I provide in the settings dialog). On Thursday, November 6, 2014 at 9:15:46 AM UTC-5, Steven Stamps wrote: > > I took a moment to do a little more research on this question, and came up > with the following solution. > It provides 1-button browsing of a live SQLite database while it is still > on the device and being modified by your app. > No IntelliJ upgrade license or purchase is required. > > Since the device monitor shipped with the sdk is based upon Eclipse, you > can use the Questoid SQLite Browser > from the device monitor. > > 1) Go to: > > https://code.google.com/p/android-sqlite-browser-for-eclipse/wiki/HowTo > > 2) Click on the Google Drive download. > > 3) Move the downloaded jar into (note that this path is for a 64-bit > development box): > > [YourAndroidSdkDirectory]/tools/lib/monitor-x86_64/plugins/AndroidSQLiteBrowser_1.0.1.jar > > 4) Restart your device monitor > > Usage notes: > - don't forget that you must change permissions on the SQLite file before > you can browse it > - the Questoid DDL parser is more strict than the Android SQLite parser in > regard to punctuation. > i.e. Multiple constraints on a table require commas in Questoid, but > are forgiven by SQLite > - just select the [name].db in File Explorer and click on the Questoid > glyph in the tool bar, > else Window - Show View -> Other -> Questoid > > Hope this makes your coding day a little smoother... > > On Friday, January 24, 2014 6:49:17 PM UTC-6, Adam Brown wrote: >> >> I saw that back in October of last year InteliJ added Android >> SQLite support to their Database Support plugin: >> >> http://blog.jetbrains.com/idea/2013/10/intellij-idea-13-eap-and-android-sqlite-database/ >> >> But that doesn't appear to be present in Android Studio (*as of 0.4.3*). >> >> I was wondering if there were plans for integrating this? It would be >> fantastically useful to have 1 click access inside the Android tab in AS to >> visually inspect your applications Databases. >> > -- You received this message because you are subscribed to the Google Groups "adt-dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
