androidsqlitesqlcipher

SQLCipher - Opening an encrypted database on desktop


I'm experimenting with SQLCipher on Android. I wrote a small app that created a database with one table and a few records on the emulator. Then, I pulled the database from the emulator onto my desktop. I've looked at the SQLCipher documentation, but I can't figure out how to actually decrypt the database on the desktop so I can query its contents. I wanted to make sure I actually inserted records. What's the easiest process to get access to the records? Thanks.


Solution

  • Following the build instructions on the SQLCipher site will allow you to compile a command line version of the sqlite3 command line shell. If you are on windows you can also purchase one of the windows binary distributions, which both include a pre-compiled windows binary shell.