3 ms·

I recommend this link to anyone contemplating storing/querying hierarchical data in sql/rdbms. The "LR Method" is the best solution I've found. Does not depen

I recommend this link to anyone contemplating storing/querying hierarchical data in sql/rdbms. The "LR Method" is the best solution I've found. Does not depend on vendor specific funcationality and/or keywords: http://kamfonas.com/id3.html http://kamfonas.com/id3.html

platz 12y ago
this is also called nested sets.. it's nice but has some tradeoffs as well
gtaylor 12y ago
We started writing a threaded discussion system using these, but it ended up being much easier to use Postgres's Recursive CTEs. Highly recommend!