News for hackers. Stuff that matters.
Re: by jelder on Friday July 11, 2025 @09:08AM (#44531722)
"use Postgres for everything" is certainly wrong, eventually. It's still the second-best choice for every new project, and most products will never see the traffic levels that justify using something more specialized. Obviously, recall.ai hit the level of traffic where Postgres was no longer ideal. I bet they don't regret it for the other parts of their product.
Re: by closeparen on Friday July 11, 2025 @12:03PM (#44533773)
They aren't even questioning its use as a database, just as an event bus.
Re: by lytedev on Friday July 11, 2025 @06:59PM (#44537646)
What is the first-best choice for a new project? SQLite?
Re: by osigurdson on Saturday July 12, 2025 @01:38AM (#44539600)
No, 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.
Re: by jelder on Saturday July 12, 2025 @12:37PM (#44543187)
That’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.