New Feature: Encrypted storage data.

[sunhuachuang]

What ?

When data is stored in the database and file system, it is encrypted.

Why ?

We cannot believe that our device storage and operating system will not steal the data we store locally, and we cannot believe that other people can directly copy and view our database files when they obtain our devices. So we need an encrypted database.

How ?

Two ways are waiting to be discussed:

1. Encrypt the database file directly, and decrypt it once when you open the application.
2. Only the fields of the database are encrypted, and when the corresponding fields are obtained, they are decrypted in real time.

[sunhuachuang]

Some references: refs

• SEE - The official implementation.
• wxSQLite - A wxWidgets style C++ wrapper that also implements SQLite's encryption.
• SQLCipher - Uses openSSL's libcrypto to implement.
• SQLiteCrypt - Custom implementation, modified API.
• botansqlite3 - botansqlite3 is an encryption codec for SQLite3 that can use any algorithms in Botan for encryption.
• sqleet - another encryption implementation, using ChaCha20/Poly1305 primitives. Note that wxSQLite mentioned above can use this as a crypto provider.

The SEE and SQLiteCrypt require the purchase of a license.