Hacker News new | ask | show | jobs
by drdrek 411 days ago
Postgres is such a cool project, I have so much respect for its maintainers and community! For me its the second most impactful OSS project in the business tech world behind Linux itself. A real public good to be cherished and praised.
2 comments

You can get no better recommendation, that a phrase I once heard at a presentation by Richard Hipp primary author of SQLite. As he was explaining how he analyzed new features and design decisions he says some of his guidance is: "What would Postgres do?"
I recently started a ML project using text data and the choice was between MySQL and Postgres. Having looked at the respective features and pros and cons, the choice was immediately obvious. Also, with pgvector and https://postgresml.com available, the choice for Postgres was even easier.
Why not MongoDB?
The question should be the other way around: why mongodb? It’s not ACID compliant so has major down sides…
According to mongodb it is acid compliant.

https://www.mongodb.com/resources/products/capabilities/acid...

I guess they didn’t need anything web scale.
Because it's web scale...