Provided your database can implement prefix string searches as an indexed range search, materializing the path is conceptually simple and avoids the write/update overhead of nested sets. I used this ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback