Re:SQLite as an Application File Format (2014)
by yellowapple on Saturday June 13, 2020 @06:54PM
(#23513540)
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.
[ Parent
| on HN ]
Re:SQLite as an Application File Format (2014)
by justinclift on Sunday June 14, 2020 @01:40AM
(#23515391)
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.