7 ms·
What is the first-best choice for a new project? SQLite?
by lytedev 1y ago
What is the first-best choice for a new project? SQLite?
- osigurdson 1y agoNo, generally Postgres, just not for everything. If you understand the tradeoffs SQLite can be fine. Once you have more than one service (even just for HA) SQLite means doing kind of crazy things like using NFS in your infra. If you know you will only have one service and can bind it to an EBS like volume it is totally fine.
- jelder 1y agoThat’s my point, there is no best-first choice for everything. There will always be trade-offs. But Postgres makes the right trade-offs to be good enough in almost every scenario.