PostgreSQL as a Graph Database: Who Grabbed a Beer Together?
Thursday, October 23 at 09:25–10:15
Graph structures can reveal patterns in connected data that traditional relational models miss, such as how communities form and evolve over time. In this session, we will explore why graph modeling is important for these types of analyses and how PostgreSQL can serve as a powerful graph database. We will compare available extensions including Apache AGE, pgRouting, and pgGraph, and discuss their strengths and recommended use cases.
Then, through a live demo using data about speakers from previous PGConf events combined with Untappd check-ins, we will visualize social interactions and shared experiences, showing how to uncover insights like who connected with whom, popular gathering spots, and how the conference community network changes over time, all with PostgreSQL.
