4 ms·
> Postgres is probably the best solution for every type of data store for 95-99% of projects. I'd say it's more like: - 95.0%: SQLite - 4.9%: Postgres - 0
by alberth 4y ago
> Postgres is probably the best solution for every type of data store for 95-99% of projects.
I'd say it's more like:
- 95.0%: SQLite
- 4.9%: Postgres
- 0.1%: Other
- roncesvalles 4y ago>95.0%: SQLite I'm a bit late to the party (also, why is everyone standing in a circle with their pants down) but, does no one care about high availability with zero data loss failover, and zero downtime deployments anymore?
- alberth 4y agoDo you think more than 5% of projects really need to have HA & zero downtime deployments? (and litestream exists for sqlite if needed)
- contravariant 4y agoThe way these things go the 5% that you need postgres or otherwise for will account for 95% of the data.
- runeks 4y agoWhy?
- SergeAx 4y agoHow do you ensure fault tolerance on SQLite?
- brohee 4y agoIn one instance I did that by storing the file on a fault tolerant NAS. Basically I outsourced the issue to NetApp. The NAS was already there to match other requirements so why not lean on IT.