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

Comments (1)

BinaryIgor · 1d 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?

Ask HN: What is a great project based Rails tutorial for 2025?

Can Software Be Durable?

Ask HN: How do I prevent AI from reading/training off my content?

Navigating AI Dementia: Strategies for Safe Rollback

Ask HN: Looking for alpha testers for HRAM (asm)

Ask HN: US expats/nomads, how do you find remote-out-of-US jobs in US?

I'm Peter Roberts, immigration attorney who does work for YC and startups. AMA

Ask HN: Any active COBOL devs here? What are you working on?

Ask HN: Recommendation for good app to read ArXiv on iOS?

After vibe coding, AI code feels numb and meaningless

Ask HN: What Pocket alternatives did you move to?

CrushFTP zero-day alert – patch now

Ask HN: Having terrible time with paid versions of ChatGPT and Claude

Metis Agent Starter Kit – Build production AI agents in minutes, not weeks

Ask HN: What could I build to make your life a little easier?

Ask HN: What's Your Useful Local LLM Stack?

Ask HN: What's the competitive advantage these days?

Which SaaS have you been able to replace with AI?

How do you retain what you read from nonfiction books?

Ask HN: Will AI models over time converge into the same system?

Ask HN: Is it time to fork HN into AI/LLM and "Everything else/other?"

Ask HN: Does anyone have OpenBSD projects looking for unpaid/paid help?

Ask HN: OpenAI zero'd balance (actual money, not free credits) after inactivity

Tell HN: Notion Desktop is monitoring your audio and network

Ask HN: Changing Developer Career Specialty

Ask HN: Is clearing browser data (cookies, cache, history) enough?

Ask HN: How do you stay on top of AI tech?

Ask HN: How are you tracking dev productivity without feeling micromanaging?

Ask HN: GCP Outage?

Ask HN: Where do you guys find audiobooks?

Ask HN: What is the best way to learn 3D modeling for 3D printing?

Ask HN: What is the state of support for mutable torrents?

Ask HN: Cursor is using 269,738 tokens to edit 1200 token file

Google raising Nest Aware Plus pricing by 25%

Ask HN: Is OpenAI Acquiring Cursor?

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

Comments (1)