if you could enable WAL without a drop in performance, you might be able to use something like litestream to sync to the backend this may be the most performan

if you could enable WAL without a drop in performance, you might be able to use something like litestream to sync to the backend this may be the most performant/secure/cheapest b2b saas stack ever every customer gets own sqlite database, downloads it to their browser on first load, each db gets synced to s3 everything is served statically from s3 as well