Install sqlite3 on your rooted Google Nexus One / Nexus S
August 5, 2011
Please note that all credit goes to Sun Chen for this solution (blogpost here: http://chensun.net/android-development/install-sqlite3-on-google-nexus-one/54/).
I simply applied the same technique to my Nexus S and have reproduced the steps below for my own future benefit.
[Notice! You must have root access on your Nexus One / Nexus S.]
1. Download sqlite3, which comes with SuperOneClickv1.7-ShortFuse, and copy it to your SD card.
2. Connect your phone to your computer. Open a Command Prompt, and type the following commands:
adb shell
$ su
# mount -o remount,rw -t yaffs2 /dev/block/mtdblock3 /system
# dd if=/sdcard/sqlite3 of=/system/bin/sqlite3
# chmod 4755 /system/bin/sqlite3
# mount -o remount,ro -t yaffs2 /dev/block/mtdblock3 /system
Done! Now you can use sqlite3 to examine database on your Nexus One / Nexus S from a Remote Shell or even from an Android Terminal Emulator.
