If you're using sqlite, but for a static website, you might consider using duckdb. It's still evolving, but it has huge potential.
It's also an embedded single file database like sqlite, but stores data in columns. Duckdb to sqlite is like redshift to postgres.
Hopefully they will add compression for string columns, so that host your entire static site from a single file in a very efficient way.