Re:SQLite Archive Files (2018)
by lifthrasiir on Monday September 27, 2021 @01:48PM
(#28673800)
I think I made it clear that ZIP encryption is "very bad" :-)
Totally fair! I think I'm mostly pushing back on the idea that archive formats with built-in encryption are a good idea.
Re:SQLite Archive Files (2018)
by lifthrasiir on Monday September 27, 2021 @03:36PM
(#28675070)
That's reasonable. Given that compression softwares are likely what typical people would use for encryption though, I'd like to see an actually good encrypted format design in a commonly used archival format. I'm even okay and more than welcome if that'd be just `age` plus some carefully selected headers.
Re:SQLite Archive Files (2018)
by nextaccountic on Monday September 27, 2021 @01:49PM
(#28673805)
To be fair, they said that ZIP had very bad encryption.
We relied on ZIP encryption at a previous firm, because no client of ours could ever get PGP to work. But we had to train everyone to use 7z, and getting files back from clients was fraught (they might just click the "encrypt" button in whichever random ZIP program they used).
If you want to encrypt an archive file, you should do it with a dedicated encryption program that you trust (Filippo Valsorda's `age` is a good bet, since it has good implementations in both Go and Rust, so it's very easy to integrate into designs, and also has a very clean, simple command line interface). You should not lean on ZIP's supposed AES support.
The rest of this critique of `sqlar` might be valid! But I can't let the encryption thing pass unchallenged.