Re:SQLite may become foundational for digital progress
by lenkite on Sunday May 22, 2022 @11:13PM
(#31475000)
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.
Re:SQLite may become foundational for digital progress
by Mertax on Monday May 23, 2022 @09:36AM
(#31478844)
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)
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.