Comment by cfn
5 years ago
I guess he/she meant that the extension that encrypts the database is proprietary. I believe that was the only option for a while but now there is an open source alternative.
5 years ago
I guess he/she meant that the extension that encrypts the database is proprietary. I believe that was the only option for a while but now there is an open source alternative.
Is the open-source alternative bidirectionally interoperable with the closed-source version (i.e. it can decrypt the proprietary encryption and the proprietary version can decrypt the FOSS version)? If so, then that's handy.
The "officially blessed" (my wording) encryption for SQLite is SEE (proprietary):
https://www.sqlite.org/see/doc/release/www/index.wiki
There are third party encryption approaches for SQLite. One of the most popular is SQLCipher:
https://github.com/sqlcipher/sqlcipher/
Those two don't have compatible file formats. eg no interoperability
Not sure if any others do, but yeah it would be handy if there are.