Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 372
Blue Dusk Avatar asked Mar 12 '12 17:03

Blue Dusk


People also ask

How do I open an encrypted database in SQLite?

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.

What encryption does SQLCipher use?

SQLCipher is an open source library that provides transparent, secure 256-bit AES encryption of SQLite database files.


1 Answers

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.

like image 190
Stephen Lombardo Avatar answered Oct 29 '22 12:10

Stephen Lombardo