Jacob Rief

2 videos · 2 events · 2018–2025 · 59 min of video

Talks

0:27:17

Representing Hierarchies in Relational Databases

DjangoCon Europe 2018 · May 23, 2018

Jacob Rief explains four ways to represent trees in relational databases: adjacency lists, materialized paths, nested sets, and recursive common table expressions. He shows how each pattern handles descendant and ancestor queries, indexing, inserts, deletes, ordering, and multiple roots, and compares their trade-offs in Django.…

Spoken at