Where can I obtain an sqlite3 command line binary for android 2.2.1?

Question

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:

• Re: SQLite3
• Using SQLite from Shell in Android
• Why does sqlite3 command using the android adb shell return “permission denied”?
• How to poke around the sqlite3 databases

Answer 1

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).

Answer 2

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).

Answer 3

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.

Answer 4

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.

Answer 5

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/