Graph Databases, and Dungeons and Dragons

on YouTube ↗32m

" summary

Maps a Dungeons & Dragons dungeon into a graph and shows concrete queries that find optimal routes and loot using RedisGraph and Cypher. The claim is that relationship and path queries become simpler and more expressive than equivalent SQL joins; examples include pattern matching with variable-length hops to list nearby rooms, compute shortest path to the biggest treasure, aggregate max gold, and order monsters by XP. Queries are shown end-to-end and return the expected paths and aggregates; demo is skipped for time.

AI-written summary · about

" chapters (13)

1. 0:00Start
2. 0:59Character Sheets
3. 3:24What's a Graph Database
4. 4:46Simplest Graph Database Is the Null Graph
5. 7:18Directed Graphs
6. 7:48Graphs Have Degrees
7. 10:00What a Graph Database Is
8. 14:25Crud Operations
9. 15:46Select Statement
10. 24:33Connect Rooms with a Relational Database
11. 26:08Pathing Queries
12. 30:54Practical Applications
13. 31:33Discord Server

" related talks

• 31mDungeons, Dragons, and Graph DatabasesGuy Royse · JSWorld Conference 2021
• 01h 01mDungeons, Dragons, and Graph DatabasesGuy Royse · NDC Oslo 2022
• 52mDungeons, Dragons, and Graph DatabasesGuy Royse · All Things Open 2020
• 51mDungeons, Dragons, and Graph Databases.Guy Royse · Devoxx Ukraine 2020
• 19mUnraveling the Web of Relationships: Understanding Graph DataMala Mahadevan · SQLBits 2024
• 26mGraph Databases will change your (freakin') lifeElena Williams · PyConline AU 2020
• 32mUnderstanding Complexly Connected Data using Graph DatabasesKarin Wolok · Women in Tech Virtual Conference 2020
• 55mA Practical Guide to Graph DatabasesDavid Bechberger · NDC Oslo 2018