Skip to content
Hallway
0:00 / 0:00

#postgresql#graphqueries#recursivequeries

Webinar: Graph Queries with PostgreSQL

EDB

11K subscribers • 2 videos on Hallway

YouTube
  • Recommended by 2 people: 2 in engineering communities.
  • Presented by Simon Riggs, Postgres Fellow at EDB
  • Made by the vendor. The company whose product it covers made or sponsored it.

Intermediate. Assumes working knowledge.

8.4K views4 years ago2 recommendations

Databases and dataPostgresSQL

Simon Riggs explains how to write and optimize graph search queries in PostgreSQL using recursive CTEs and new SQL features.

For more #webinars​​​​​, visit enterprisedb.com/resources/webinars ---------------------------------------------------------------------------------------------- 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 ---------------------------------------------------------------------------------------------- For more #webinars​​​​​, visit enterprisedb.com/resources/webinars Download #PostgreSQL​​​​​ whitepapers: enterprisedb.com/resources/white-papers Read our #Postgres​​​​​ Blog enterprisedb.com/blog Follow us on Facebook at facebook.com/EDBpostgres Follow us on Twitter at twitter.com/edbpostgres Follow us on LinkedIn at linkedin.com/company/edbpostgres Reach us via email at marketing@enterprisedb.com

Why it's here

2 people recommend this

What people say. Recommended as an excellent guide on how to performantly write graph queries natively in PostgreSQL.

u/program_data2in r/PostgreSQL • Recommends

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

I'd like to add that Postgres supports graph queries currently without AGE. Simon Riggs (RIP), a former core maintainer of Postgres, gave a lecture on how to performantly write graph queries for Postgres. Paul Ramsey, lead maintainer of Postgis, also wrote an article on the topic. Although I am a fan of AGE, it's not obvious to me how it optimizes better than Postgres's native support for graph queries.
2View on Reddit

u/RevolutionaryRush717in r/PostgreSQL • Recommends

On “Representing graphs in Postgresql”

There is this talk illustrating graphs in PostgreSQL using recursive queries: link to this video
1View on Reddit