How to install SQLite executable on Android device?

Question

I have a root application that reads an WhatsApp SQLite database. I am using sqlite binary to execute an SQL query and I am reading the results in my application.

Now everything works fine, but I noticed that the SQLite executable seems to be missing on some devices, especially the Galaxy S3 GT-I9300. (I see this through crash statistics.)

My application also installs the sqlite3 on the user's phone. The SQLite executable must be located in /system/xbin/sqlite3 or /system/bin/sqlite3 . I linked the sqlite3 binary to my application in assets and my application unpacks the assets and copies them to the right place. I extracted sqlite3 binary from Android emulator.

Now I see errors reading this libncurses.so library libncurses.so . On my phone, this file is located in /system/bin/libncurses.so .

Now, should I also link the libncurses.so file with my application? Is there anything else I need to relate?

If there is a better way to get sqlite3 on the device, I will be glad to hear it.

Answer 1

You are root, you can use this application

https://play.google.com/store/apps/details?id=ptSoft.util.sqlite3forroot&feature=search_result#?t=W251bGwsMSwyLDEsInB0U29mdC51dGlsLnNxbGl0ZTNmb3Jyb290Il0 .

Answer 2

if you want to avoid dependencies, just create it yourself with all the necessary libraries statically linked.

Answer 3

Some searches in SO will lead to many answers:

Here is one of them: Why am I getting a "sqlite3: not found" error in the root of the Nexus One when I try to open the database using the adb shell?