Debugging and SQL

[Russell Wheeler]

I am new to using AIDE, and have so far only followed a few tutorials.

I am asking how you guys deal with debugging and checking your sqlite dbs, when you develop on your devices using AIDE.

So far the only way I know of being able to view them (and I haven't actually tried this myself yet) is to have a rooted phone.

I have logged in via adb from my computer and used the 'run-as' command to behave as the app user itself, which lets me see the db, and then copy it (using cat) to my sdcard so that I can see it in the device at any time, using an sqlite manager app.

My issue is the whole point of AIDE is developing on the device with no need for a computer. So how do you guys look at your dbs? Do you only do db stuff when you have a computer to connect to it, are you all rooted, or is there something else I haven't found?

Thanks

Russ

p.s. I have tried using connectbot to get into the local shell of my phone. This works fine but I can't use the run-as command as I don't have permission. I tried copying the file from my computer where I'd changed the executable permissions, but when I copied it using adb push, the permissions were removed. Maybe I can login with a diff user in connectbot to retain executable permissions?

[Sean Bell]

I would root my phone asap. It is super easy for most devices, and will have zero negative impact unless you get carried away in a root file manager and start deleting system files :).

I can view any file anywhere in my filesystem, Internal or sdCard. It is the way to go for you i think.

Sean

[Russell Wheeler]

I agree that this may very well be the way forward, but I can't find anyway to root my Galaxy Nexus, without wiping the data.

And I've rooted before on old phones where I needed to add a custom Rom to improve performance. It was a massive ballache, reinstalling all my apps, text messages, etc.

My current solution is to attempt to copy the db onto my sdcard for debugging purposes.

[Sean Bell]

I used Wug's Nexus Toolkit to backup everything via ADB. I was then able to root then restore most of my data.

[Russell Wheeler]

On Friday, September 21, 2012 10:33:13 PM UTC+1, Sean Bell wrote:
> I used Wug's Nexus Toolkit to backup everything via ADB. I was then able to root then restore most of my data.

Most......hmmmm.

I'm just going to setup a copy directly to my sdcard to help with debugging.

Cheers though

[ArBaSoD]

Well, I have your answer:

Root without unlocking Bootloader, thus not wiping data: http://forum.xda-developers.com/showthread.php?t=1894717

-- It is in the Galaxy Nexus forum, so you can be absolutely sure it works for you. Anyway, it should work on almost every device, and I can assure it works for Nexus 7 :D

I was exactly like you, looking for a way to root, just to use AIDE's logcat, but not willing to wipe and restore...

Enjoy!

El divendres 21 de setembre de 2012 10:55:52 UTC+2, Russell Wheeler va escriure:

[Russell Wheeler]

Wow, i hope this works. Thanks for following up.

My work around has been to copy the db to sd card after every interaction, not ideal but works well. If you need me to, i can post the code here how to do it. Its only about 10 lines.

Thanks again, i'll try it this weekend on the n7 at least.

Russ