Webinar: Graph Queries with PostgreSQL

----------------------------------------------------------------------------------------------
PostgreSQL allows recursive queries that can be used to write graph search queries. This talk looks at how to write and tune queries, as well as design databases for efficient graph search. We’ll also discuss the new SEARCH and CYCLE clauses in #PostgreSQL14.
Key Takeaways:
- Writing graph queries in SQL Optimizing shortest path searches
- Utilizing new graph features in PostgreSQL 14
- Designing graph databases using #PostgreSQL.

Speaker: Simon Riggs, Postgres Fellow, #EDB

----------------------------------------------------------------------------------------------

[andreasnulein]

Thanks Simon, this helped me a lot just now!

[warnerkevins]

Thank you for a very interesting presentation. What are the tradeoffs with using a single table approach as shown in this example, vs a separate table for the relationships? Would there be any good reasons to choose one over the other? Thanks!

[tobiasne]

It would be really nice, if someone could write an up to date book about this topic

[magick]

Would be good to see this updated to included Apache AGE

[davidpaez_co]

Please someone correct me if I'm wrong, but he didn't address the ability to add and query properties of edges. It does not seem possible given his modeling assumptions.

His examples were based in a single table (each row is a node) so you could only add properties to nodes (by adding columns to that table).

[ø_ø-co]

There appears to be an error at 27:00. Could someone write that query so it runs?