SQLCipher is a third-party software solution that was developed in order to help seasoned computer users such as database or server administrators protect their SQLite database contents without significant efforts.
The tool is actually an extension for SQLite and makes use of a 256-bit AES encryption to protect database against prying eyes. It provides users with transparent encryption by simply locking the data pages before being written to storage and decrypted upon reading them.
SQLCipher can provide you with a fully-encrypted SQLite database. The program is fast with indexes and transactions, but other operations or sections as well. By using this software solution, users will make sure that no unencrypted data will be written to their disks, since SQLite’s page caching enables decrypted pages to be stored in memory without efforts.
As stated above, this tool relies on the OpenSSL library to meet encryption
requirements, which includes the AES-256 algorithm, PBKDF2 key derivation and pseudo random number generation.
The package is available in a lightweight archive that can be decompressed and used by simply integrating its functionality in SQLite. Since it’s a lightweight tool, it can be used for mobile applications just as well.