Storing hierarchical (tree) data in SQL using Ruby on Rails
I have a Ruby On Rails project with a fair amount of hierarchical data. I have already tried a few different techniques of managing this data. Nested sets and materialized paths sound good in theory but in practice they didn’t work out so well. Here are some thoughts thus far.