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.

Reply via email to