SQLite Forum

ZIPVFS questions
Right. That's 3 orders of magnitude larger than my case :)

I packed 4 DBs totalling 5.4MB into a <900KB zip file.

In your case, it depends how big each DB inside the ZIP would be.  
And how many of those DBs you need to keep in memory at any one time.

If OTOH what is big in inside single-cell-values, you could use https://www.sqlite.org/src/file/ext/misc/compress.c instead, similar  
to how https://sqlite.org/sqlar/doc/trunk/README.md emulates / replicates a ZIP.

But it could well be that zipvfs is better for you indeed.  
And going commercial, you then have the full support of DRH and Dan! :)