How do I store and query tree data (categories, comments, org charts) in SQL?
Adjacency lists, materialized paths, nested sets and closure tables compared, and why a parent_id column plus a recursive CTE is the right default.
#data-modeling#schema-design
