HNGlance

Top Best New Show

Experimenting with SQL:2023 Property-Graph Queries in Postgres 18

https://gavinray97.github.io/blog/postgres-sql-property-graphs

by gavinray • 1 year ago

2 1 1 year ago

GA

gavinray97.github.io

Related Stories

Loading related stories...

Comments

1

BinaryIgor• 1 year ago

Interesting to see that after having (no longer so basic) support for JSON documents we will right now have graphs in SQL databases as well.

Although there probably are less use cases for graphs that there are for non or semi-structured data in stored in JSON documents, use cases do exist and they often are annoying to model using just tables, joins and standard relationships (SQL-wise).

On the other side, it will make SQL databases (their implementations) even more complex than they already are.

I would be also interested to see how, in the article there's Postgres example, it was implemented under the hood, so it has acceptable performance; I guess similarly to joins?

Source preview

gavinray97.github.io

HNGlance

© 2024-2026 HN Glance. Story content belongs to its original sources.

Privacy
Terms