News for hackers. Stuff that matters.
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).

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.
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
Re:Comparing PostgreSQL-Compatible Databases: From Amazon RD... by mbautin on Wednesday August 09, 2023 @12:47PM (#37065375)
Another useful angle to look at the PostgreSQL-compatible database landscape would probably be fully open source (e.g. Apache licensed) vs. almost open-source (e.g. AGPL or commercial licenses that convert to Apache after a few years) vs. closed source. For a variety of reasons, many large organizations that seek to build an internal multi-cloud / hybrid cloud database-as-a-service platform strongly prefer fully open-source solutions.
Re:Comparing PostgreSQL-Compatible Databases: From Amazon RD... by basique on Wednesday August 09, 2023 @02:13PM (#37066500)
AGPL isn't open source?
Re:Comparing PostgreSQL-Compatible Databases: From Amazon RD... by justinclift on Wednesday August 09, 2023 @02:17PM (#37066551)
AGPL is definitely "fully open source".