4 ms·
> Yea, but does it scale? Yes, for 100 users maybe. But you have 100 000 small sqlite db:s If it's a case of 1 node per customer (node being vm, lambda, cloudf
by biorach 3y ago
> Yea, but does it scale? Yes, for 100 users maybe. But you have 100 000 small sqlite db:s
If it's a case of 1 node per customer (node being vm, lambda, cloudflare worker, whatever) then there should be no limit.
Maybe you're thinking of a more "traditional" approach with a server process managing 1 sqlite db per customer, which might make sense in order to keep cloud costs down. Even in that case it should be trivially easy to distribute the load.
- victorbjorklund 3y agoSo store sqlite on S3. Start a new lambda (or similar) per user, download the db from sqlite and write to it and upload it again. And making sure there can never be more than 1 function running per user (to avoid two lambdas editing the same database). Seems a bit fragil but I might be wrong.