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)