Re: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

On Thu, Jan 20, 2011 at 12:05:53PM -0800, David Harkness wrote: > On Thu, Jan 20, 2011 at 7:00 AM, Richard Quadling <rquadling@gmail.com>wrote: > > > I'd recommend using a nested set approach for the tags > > (http://dev.mysql.com/tech-resources/articles/hierarchical-data.html > > gives a good explanation on the issues and methodology of nested > > sets). > > > > Thanks for the link. That article proposes an interesting way to organize > the categories. Have you implemented this in the wild? Clearly the design > would work as it's pretty simple, and I like that it removes the need for > recursive queries. > > Dotan, the Venn diagrams are just used to explain the concept. If you use > the code to determine the left and right values, you can ignore the diagrams > entirely. As long as you're not adding/removing categories every minute, > having to recalculate left and right values isn't that big of a deal. For the curious, here is a different article which explains the same concept: http://articles.sitepoint.com/article/hierarchical-data-database Paul -- Paul M. Foster http://noferblatz.com