Question regarding the new SQL standard

Anders Kildemand <AndKil@erst.dk> writes:

What's the situation with Property Graph Queries in Postgres?

There isn't any.

I've heard that it has become part of the SQL standard from this blog: https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
How far in development is this feature? and is there an expected time frame for when it'll be finished?

I think you have a fundamental misunderstanding about how Postgres
development works. There is plenty of stuff in the standard that
nobody has any particular interest in implementing for PG. Perhaps
someone will take an interest in implementing this feature, or
perhaps not. But there's no project-wide goal to make it happen,
much less a timetable. Even if someone does take an interest,
they might not succeed in producing a committable patch.

regards, tom lane

I'd like to express my appreciation for a project with a feature set so
extensive that a person might mistakenly assume that its goal was to cover
the spec comprehensively.

On Thu, Oct 26, 2023 at 10:32 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

Anders Kildemand <AndKil@erst.dk> writes:

What's the situation with Property Graph Queries in Postgres?

There isn't any.

I've heard that it has become part of the SQL standard from this blog:

https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new

How far in development is this feature? and is there an expected time

frame for when it'll be finished?

I think you have a fundamental misunderstanding about how Postgres
development works. There is plenty of stuff in the standard that
nobody has any particular interest in implementing for PG. Perhaps
someone will take an interest in implementing this feature, or
perhaps not. But there's no project-wide goal to make it happen,
much less a timetable. Even if someone does take an interest,
they might not succeed in producing a committable patch.

regards, tom lane

--
Ray Brinzer

Anders Kildemand <AndKil@erst.dk> ezt írta (időpont: 2023. okt. 26., Cs,
14:38):

What's the situation with Property Graph Queries in Postgres?

If the underlying question is how to utilize graph database functionality
in PostgreSQL, there are similar extensions that may be worth exploring:
- Apache AGE is a PostgreSQL extension that provides graph database
functionality. https://age.apache.org/
- AgensGraph is a transactional graph database based on PostgreSQL.
https://github.com/bitnine-oss/agensgraph
- etc.

Related : https://www.dylanpaulus.com/posts/postgres-is-a-graph-database/
( https://news.ycombinator.com/item?id=35386948 )

Best regards,
Imre

On Thu, Oct 26, 2023 at 11:46:18AM -0400, Raymond Brinzer wrote:

I'd like to express my appreciation for a project with a feature set so
extensive that a person might mistakenly assume that its goal was to cover the
spec comprehensively.

Okay, I couldn't stop smiling from this comment. :-)

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.