PostgreSQL 19 connects the dots with standardized graph queries

Baked-in SQL syntax arrives through multi-vendor collaboration, although indexing still needs to catch up

PostgreSQL 19 is set to add standardized SQL syntax for querying property graphs.

The open source database has steadily grown in popularity over the last five years, becoming the most popular among developers for the first time in 2023.

Speaking to The Register, Alastair Turner, PostgreSQL evangelist at open source consultancy Percona, said the property graph query support in PostgreSQL 19 – due later this month or early October – resulted from collaboration among several of the database's largest contributors.

Graph databases store data as nodes, relationships, and properties rather than tables or documents. They have advantages for certain workloads, but adopting one can mean adding another DBMS to the technology stack.

The relational database has been acquiring graph query capabilitiesfor some time, but PostgreSQL 19 is set to go further, Turner explained. "All...

Copyright of this story solely belongs to www.theregister.com. To see the full text click HERE