[wp-trac] Re: [WordPress Trac] #4189: Taxonomy Schema and API

[WordPress Trac]

#4189: Taxonomy Schema and API
-------------------------------------------+--------------------------------
 Reporter:  ryan                           |        Owner:  anonymous
     Type:  defect                         |       Status:  new      
 Priority:  normal                         |    Milestone:  2.3      
Component:  General                        |      Version:  2.2      
 Severity:  normal                         |   Resolution:           
 Keywords:  term taxonomy tags categories  |  
-------------------------------------------+--------------------------------
Comment (by majelbstoat):

 Seeing as categories are going to be changing so much, I wondered if it
 might be a good time to consider an alternative hierarchical
 implementation in the database?  This article makes a good case for nested
 set categories:

 http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

 To implement this, we'd need a left and right column instead of a parent
 column.  I quite like this anyway, as it also allows for more complicated
 taxonomy schemes, such as linked lists.  There are lots of benefits to
 using this as opposed to our current method, the main of which is that it
 is optimised for retrieving data, rather than inserting.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4189#comment:1>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software