• After 15+ years, we've made a big change: Android Forums is now Early Bird Club. Learn more here.

Root SQLite Database Editor

D

dhahne

Newbie
I am looking for a way to edit SQLite databases on my rooted Nook Color. I know about SQLite Editor but I need to edit the database on two different Nooks so I would really like not to have buy it twice. Is there a free editor out there or can SQLite Editor be run from the SD card?
 
Can you buy the Amazon version and install the Amazon app store on both and remove it from the 2nd when done?
 
I have the Amazon market installed - not sure how that helps. Does Amazon give you a window within which you can try an app before they charge you?
 
Amazon is an app that doesn't use the same criteria as Google Market.

If I have device "a" registered to my gmail acct and device "b" registered to my wife, apps I buy do not help my wife. She'd also have to buy them.

If I install Amazon's app store and use the same email account (mine) for both, I can buy the app once and install on both.

Market used to give you an hour or so to try an app and get your money back. That's closer to minutes now. I don't know what the timeout is for returns for Amazon tho.

You could try GetJar and see if a sql editor is available there. I've installed some from there that would have cost me if installed via Market or Amazon.
 
Thanks, I'll check them all out.
colchiro said:
Amazon is an app that doesn't use the same criteria as Google Market.

If I have device "a" registered to my gmail acct and device "b" registered to my wife, apps I buy do not help my wife. She'd also have to buy them.

If I install Amazon's app store and use the same email account (mine) for both, I can buy the app once and install on both.

Market used to give you an hour or so to try an app and get your money back. That's closer to minutes now. I don't know what the timeout is for returns for Amazon tho.

You could try GetJar and see if a sql editor is available there. I've installed some from there that would have cost me if installed via Market or Amazon.
Click to expand...
 
what device did you set at GetJar in order to download an app. everything I try keeps telling me it is incompatible.
colchiro said:
Amazon is an app that doesn't use the same criteria as Google Market.

If I have device "a" registered to my gmail acct and device "b" registered to my wife, apps I buy do not help my wife. She'd also have to buy them.

If I install Amazon's app store and use the same email account (mine) for both, I can buy the app once and install on both.

Market used to give you an hour or so to try an app and get your money back. That's closer to minutes now. I don't know what the timeout is for returns for Amazon tho.

You could try GetJar and see if a sql editor is available there. I've installed some from there that would have cost me if installed via Market or Amazon.
Click to expand...
 
Can SQLite Editor be moved and run from the SD card? Can apps that run from an SD card be moved from Nook to Nook by moving the SD card? Thanks.
 
dhahne said:
Can SQLite Editor be moved and run from the SD card? Can apps that run from an SD card be moved from Nook to Nook by moving the SD card? Thanks.
Click to expand...
I often use Android Assistant to backup apps that I want to transfer in this manner. The nice thing about AA is that it creates .apks that can be installed on another device.

Of course, if the app incorporates license checks, it still might not function.
 
dhahne said:
I am looking for a way to edit SQLite databases on my rooted Nook Color. I know about SQLite Editor but I need to edit the database on two different Nooks so I would really like not to have buy it twice. Is there a free editor out there or can SQLite Editor be run from the SD card?
Click to expand...
If you connect to the Android Market using the same account, even temporarily, you can access the same purchased apps from two devices. Hell, I use the same account on 5 devices and it works. After you do the deed, you can change accounts.

If you're feeling really studly, though, you can use sqlite3 directly. Open up your manualnooter .zip archive and take a look at /tmp. In there, you'll find the sqlite binary, and in the /tmp/scripts directory, you'll find the database.sh installer script that uses it. You could modify the mn .zip to make your mods directly when you install the .zip from CWM.

Here's an article on using sqlite3 directly from the command prompt. Here's another on using it to block OTA updates.
 
Thanks, I'll take a look.

bobstro said:
If you connect to the Android Market using the same account, even temporarily, you can access the same purchased apps from two devices. Hell, I use the same account on 5 devices and it works. After you do the deed, you can change accounts.

If you're feeling really studly, though, you can use sqlite3 directly. Open up your manualnooter .zip archive and take a look at /tmp. In there, you'll find the sqlite binary, and in the /tmp/scripts directory, you'll find the database.sh installer script that uses it. You could modify the mn .zip to make your mods directly when you install the .zip from CWM.

Here's an article on using sqlite3 directly from the command prompt. Here's another on using it to block OTA updates.
Click to expand...
 
You must log in or register to reply here.
Back
Top Bottom