Relational or graphs? Why not both?
October 20–23
Level: Intermediate
Is PostgreSQL good enough to satisfy all your graph database needs? Relational databases store data in tables, graph databases store data in nodes and edges. Or so is the common wisdom. But look one layer deeper and both store data as blocks on a disk. And in the world of databases, storage layout is what determines performance.
In this talk I will explore options for mapping graphs onto a relational database. What are the upsides and downsides of each one and how to write common graph queries. We will also see how SQL/PGQ coming in PostgreSQL 19 makes things easier and what the future additions will improve.
