Using a distributed SQLite database cloud (with a DaaS provider like Turso) you can solve three pain points that has traditionally plagued web dev.
- Active search without client-side caching: You can have DB and server on close Edge, so the time delay will be negligible.
- Multi-tenancy with DB per tenant: You can have your own Sqlite db:s for organisations and thus not have extra
WHERE org_id = ?
queries anymore.
- Easy testing and dev branches: You can spin up a DB on close Edge per dev or QA and have them make preliminary tests in isolation.
Read the full blog post here:
https://dev.to/hanshoi/why-should-you-replace-your-postgresql-with-2000-sqlite-databases-5e0d