Take the 2-minute tour ×
Android Enthusiasts Stack Exchange is a question and answer site for enthusiasts and power users of the Android operating system. It's 100% free, no registration required.

When I read documentation such as Examining sqlite3 databases from a remote shell I get the impression an sqlite command-line binary should exist on my phone. Sadly I can't seem to find it on my phone (but I'm running a custom rom.)

I've read a few other posts that either allude to the existence of such a binary or mention how it is only available in the emulator, but there is nothing definitive.

Does anybody know if such a binary is available anywhere?

Other refs:

share|improve this question
1  
I suppose you could try pulling it from another ROM (or the emulator) and putting it on your device, but I have no idea if that would work or just crash. CM6, for instance, has the sqlite3 binary. –  eldarerathis Jan 22 '11 at 2:59
    
on my Samsung Spica -- using Samdroid mod -- I can just type sqlite3 in terminal emulator or adb shell. –  Lie Ryan Jan 22 '11 at 3:15
2  
Is this a dev question? –  Matthew Read Jan 22 '11 at 12:48
1  
@Matthew - nope –  fostandy Jan 23 '11 at 19:47
add comment

5 Answers 5

As other posts have mentioned, the sqlite3 binary is typically used via ADB from your PC.

If all you want to do is manage SQLite DBs locally, then I've found the free app aSQLiteManager very useful. In addition to a simple GUI for managing and viewing data, it allows running of arbitrary queries.

share|improve this answer
add comment

SuperOneClick actually has a copy of the binary. It lives in the Dependencies folder, and according to one poster on Stack Overflow, it works when pushed onto your device (I assume it must work on most devices since SuperOneClick uses it).

share|improve this answer
add comment

A little complicated process I will suggest, because I am not aware of other ways :) , get the Android source code , compile it , in the output directory you will get sqlite3 binary , then push it to your phone's /system/bin/

share|improve this answer
add comment

Pulling it off of the emulator won't work.

I found a 1.6 binary here. That page details information on porting, so if the 1.6 binary doesn't work, you can try porting/compiling a new version.

share|improve this answer
add comment

Your best bet would be to use ADB and pull it off the emulator, or pull it from another rom. You will then have to put it on your device, but you will have to have root to put it in the directory with the other binaries.

sqlite3 does not come on most of the devices, I think it only comes on the dev phones, like ADP1/ADP2, Nexus One/Nexus S. I know it is not on the Samsung Galaxy S devices such as the Vibrant (I am guessing its on the Nexus S).

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.