Support for SQLCipher encryption is available in Valentina Studio, Valentina Database ADKs (which support SQLite), and Valentina Server.
SQLCipher is a standalone fork of SQLite that adds 256 bit AES encryption of SQLite database files. According to the open source project of SQLCipher it offers the following benefits:
- Fast performance with as little as 5-15% overhead for encryption on many operations
- 100% of data in the database file is encrypted
- Good security practices (CBC mode, HMAC, key derivation)
- Zero-configuration and application level cryptography
- Support for multiple cryptographic providers
SQLiteCipher offers a number of benefits over SQLite Encryption Extension (SEE), the closed source alternative. SQLiteCipher offers modern cryptography, open-source auditability, and very wide ecosystem support.
SQCipher in Valentina Studio
Valentina Studio works with both non-encrypted SQLite databases and SQLCipher encrypted databases.
Encrypting a SQLite database with SQLCipher with Studio |
Opening an encrypted SQLCipher SQLite database with Studio |
Changing the encryption key of a SQLCipher SQLite database with Studio |
Decrypting an encrypted SQLCipher SQLite database with Studio |
SQLCipher in Valentina Server
Valentina SQLite Server is a part of Valentina Server.
Valentina SQLite Server also supports SQLCipher encryption.
SQLCipher in Valentina Database ADK
Some versions of the Valentina Database ADK runtime support local storage of SQLite databases.
Those versions that support SQLite databases also support SQLCipher encryption.