Recursive categories

[eluser]Pascal Kriete[/eluser]
I'm gonna toss in a third method that I like a lot. The materialized path model, which is good for any depth tree that has to deal with a lot of insertions (particularly leaf nodes).

Select's aren't as efficient as the nested sets, but writes are not as volatile (no need to re-index half the tree).