On Thu, Jan 20, 2011 at 12:05:53PM -0800, David Harkness wrote:

> On Thu, Jan 20, 2011 at 7:00 AM, Richard Quadling <rquadl...@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



Paul M. Foster

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to