How to test whether database is encrypted after adding SQLCipher?

Question

After adding the SQLCipher libs, and adding calls to

SQLiteDatabase.loadLibs(context);

How do I confirm that my app database is encrypted?

I tried accessing the .db via adb. adb shell says permissions denied or error when trying to access the db file for inspection.

Answer 1

I tried accessing the .db via adb. adb shell says permissions denied or error when trying to access the db file for inspection.

Use an emulator and DDMS or adb pull (see this blog post for a shell script for the latter).

Or use adb shell run-as on a production device, assuming the device isn't seriously old.

However, you still will be unable to open the database, unless you are using a SQLCipher-enabled copy of sqlite3 or some other client.