Readers may find Pack interesting: https://news.ycombinator.com/item?id=39793805
Theres is "Pack" archive format that does exactly this for general-purpose archives (sqlite + zstd for compression). https://news.ycombinator.com/item?id=39793805 https://pack.ac/
works faster AND more compact than .tar.zstd and .7z.zstd (patched 7z with zstd compression)
Readers may find Pack interesting: https://news.ycombinator.com/item?id=39793805