The problem of how to handle trees in SQL has been talked about alot. The basic 3 ways are:
- store the full path for each entry
- store the parent for each node
- use nested tree
Nested tree is good for read-many-write-less applications where the tree doesn't check over time ...more ...