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.
Right-click on your db file in its folder and select "open with..." then select the exe for SQLite2009 Pro, or drag the file onto the exe (assuming you're on Windows), or pass the file path to the exe via the cmd line.
SQLCipher is an open source library that provides transparent, secure 256-bit AES encryption of SQLite database files.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With