sqlite - Encrypted file or db in python

Question

I have a sqlite3 db which i insert/select from in python. The app works great but i want to tweak it so no one can read from the DB without a password. How can i do this in python? note i have no idea where to start.

Answer 1

You can use SQLCipher.

http://sqlcipher.net/

Open Source Full Database Encryption for SQLite

SQLCipher is an SQLite extension that provides transparent 256-bit AES encryption of database files. Pages are encrypted before being written to disk and are decrypted when read back. Due to the small footprint and great performance it’s ideal for protecting embedded application databases and is well suited for mobile development.

1. Blazing fast performance with as little as 5-15% overhead for encryption on many operations
2. 100% of data in the database file is encrypted Uses good security practices (CBC mode, key derivation)
3. Zero-configuration and application level cryptography Broad platform
4. support: works with C/C++, Obj-C, QT, Win32/.NET, Java, Python, Ruby, etc on Windows, Linux, iPhone/iOS…