News for hackers. Stuff that matters.

A comment on SQLite as an Application File Format (2014). Parent comment

Re:SQLite as an Application File Format (2014) by cfn on Saturday June 13, 2020 @12:33PM (#23510618)
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.
[ Parent | on HN ]
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.

[ Parent | on HN ]