pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion regarding the new SQL standard
5+ messages / 5 participants
[nested] [flat]
* Question regarding the new SQL standard
@ 2023-10-26 12:37 Anders Kildemand <AndKil@erst.dk>
0 siblings, 2 replies; 5+ messages in thread
From: Anders Kildemand @ 2023-10-26 12:37 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hello!
What's the situation with Property Graph Queries in Postgres?
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?
Best regards
Anders Kildemand
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Question regarding the new SQL standard
@ 2023-10-26 14:32 Tom Lane <tgl@sss.pgh.pa.us>
parent: Anders Kildemand <AndKil@erst.dk>
1 sibling, 1 reply; 5+ messages in thread
From: Tom Lane @ 2023-10-26 14:32 UTC (permalink / raw)
To: Anders Kildemand <AndKil@erst.dk>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Question regarding the new SQL standard
@ 2023-10-26 15:46 Raymond Brinzer <ray.brinzer@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Raymond Brinzer @ 2023-10-26 15:46 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Anders Kildemand <AndKil@erst.dk>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Question regarding the new SQL standard
@ 2023-10-26 17:45 Imre Samu <pella.samu@gmail.com>
parent: Anders Kildemand <AndKil@erst.dk>
1 sibling, 0 replies; 5+ messages in thread
From: Imre Samu @ 2023-10-26 17:45 UTC (permalink / raw)
To: Anders Kildemand <AndKil@erst.dk>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Question regarding the new SQL standard
@ 2023-10-26 22:04 Bruce Momjian <bruce@momjian.us>
parent: Raymond Brinzer <ray.brinzer@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2023-10-26 22:04 UTC (permalink / raw)
To: Raymond Brinzer <ray.brinzer@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Anders Kildemand <AndKil@erst.dk>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-10-26 22:04 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-26 12:37 Question regarding the new SQL standard Anders Kildemand <AndKil@erst.dk>
2023-10-26 14:32 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-10-26 15:46 ` Raymond Brinzer <ray.brinzer@gmail.com>
2023-10-26 22:04 ` Bruce Momjian <bruce@momjian.us>
2023-10-26 17:45 ` Imre Samu <pella.samu@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox