4 ms·

I think the potential exists for many multi-tenancy B2B SaaS products to be converted to an SQLite-per-tenant model. CRUD Database products like Jira, Salesfor

by Mertax 4y ago

I think the potential exists for many multi-tenancy B2B SaaS products to be converted to an SQLite-per-tenant model. CRUD Database products like Jira, Salesforce, Airtable, Notion, Clickup, Asana, etc. seem like internal line of business services that just need to be thick clients with a distributed database. Most individual businesses/tenants won’t have to deal with more than 100 concurrent writes at a time (if that) so SQLite could definitely handle that.

lenkite 4y ago
How does one handle HA and failover with SQLite ? These products you mentioned are more than just simple CRUD and have full plugin engines and workflows.
- Mertax 4y ago
  I’d be curious how products like GitHub/BitBucket handle this with git repository hosting, because I’d imagine it would not be much different. Also if you took a truly local first approach, then fully distributing the database amongst peers and supporting peer to peer synchronization would be another way (which would work for use cases with smaller data storage requirements)
- tlb 4y ago
  For most of those products, a commodity server is more reliable than the software itself. A straightforward hourly backup with manual recovery is adequate for most orgs.