News for hackers. Stuff that matters.

A comment on Comparing PostgreSQL-Compatible Databases: From Amazon RDS to YugabyteDB.

Re:Comparing PostgreSQL-Compatible Databases: From Amazon RD... by noobee on Wednesday August 09, 2023 @12:26PM (#37065049)
One thing that I would find cool as a follow-up to this article would be something like a decision tree (I understand it would get very complicated, very fast, but it should be fun): I, as a developer, am using AWS/Azure and I need features X,Y,Z, tell me which database I should pick.

Probably even better if it were a model trained extensively on the documentation / features of each individual database and it would also give references to the answer (see how Bing does it).

[ Parent | on HN ]
Re:Comparing PostgreSQL-Compatible Databases: From Amazon RD... by proleisuretour on Wednesday August 09, 2023 @12:29PM (#37065100)
There's a big difference between wire and syntax compatibility. This compatibility matrix does a nice job of showing the differences between vendors. But yeah, purpose-built databases have a place.
[ Parent | on HN ]
Re:Comparing PostgreSQL-Compatible Databases: From Amazon RD... by franckpachot on Wednesday August 09, 2023 @12:53PM (#37065452)
Many decision trees I've seen when NoSQL purpose-built were becoming popular are obsolete now that the main SQL databases have structures, APIs and optimisations for non-relational models: JSONB, Text Search, Timeseries, Documents... Today, the differentiator on architecture goals: converged database vs. multiple services
[ Parent | on HN ]