Glad it helped.
I'm a principal software engineer at Zynga these days, so use the
technique all the time.
Best...
On 04/21/2015 09:57 AM, Shii Itsu wrote:
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
<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/
<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 a topic in the
Google Groups "adt-dev" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/adt-dev/Jqw9VslC_Vw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
[email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
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.
