Graph databases, PostgreSQL and SQL/PGQ
summary
Maps relational tables to property graphs so rows become nodes and foreign keys become edges, and demonstrates SQL/PGQ as a SQL standard that lets you write graph MATCH patterns inside SQL. Shows a PostgreSQL patch (available on hackers) that implements CREATE/ALTER/DROP DDL, basic path patterns and label disjunctions but not all quantifiers or embedded patterns yet, aims for inclusion after pg18 toward pg19, and asks for code reviewers and testers. Includes concrete examples: fraud-pattern traversal and a one-line product-via-credit-card query over a 24-table schema.
AI-written summary · about
chapters (7)
- 0:00Introduction and context
- 1:33What are graph databases
- 10:56SQL/PGQ standard overview
- 28:14Querying relational data as graphs
- 36:53Advantages of SQL/PGQ
- 39:46PostgreSQL graph extensions
- 42:18Community involvement and future
related talks
27mExploring property graphs with SQL/PGQ in PostgreSQL
31mWhen property graphs join SQL
06mUnlocking graph analytics in DuckDB with SQL/PGQ
51mExploring Postgres Databases with Graphs
46mPostgreSQL as a Graph Database: Who Grabbed a Beer Together?
41mGraphGen: Conducting Graph Analytics over Relational Databases
22mQuerying & Visualizing Graphs in Postgres with Apache AGE
29mAll about graphs in Database