Earlier quoted context omitted.
I agree with the thrust of this and suggest taking it further by using SQLite for the underlying file format. The advantages of SQLite are too numerous to list, and it has a built-in compressed format so there's no bloat to worry about vs. ZIP files. As an example, this should make it practical, given a few iterations, to store multiple snapshots as deltas, deduplicating identical content. It also obviates having to…
One disadvantage is it introduces an application dependency. If the purpose of an archive is to preserve the data for future recall, years or decades later, having it in the most accessible format possible would be a priority.
SQLite is a recommended storage format (https://www.sqlite.org/locrsf.html) by the library of congress
> As of this writing (2018-05-29) the only other recommended storage formats for datasets are XML, JSON, and CSV