[wp-trac] [WordPress Trac] #14513: Time for a wp_post_relationships table?

[WordPress Trac]

#14513: Time for a wp_post_relationships table?
-----------------------------+----------------------------------------------
 Reporter:  mikeschinkel     |        Owner:          
     Type:  feature request  |       Status:  reopened
 Priority:  normal           |    Milestone:          
Component:  Post Types       |      Version:  3.0.1   
 Severity:  normal           |   Resolution:          
 Keywords:                   |  
-----------------------------+----------------------------------------------

Comment(by Denis-de-Bernardy):

 Replying to [comment:8 mikeschinkel]:
 > Does anyone else thinks post-to-post relationships are fairly niche?
 Surely not scribu, he wrote a plugin to address the use-case. Nacin points
 out that it is an "increasingly used case." Denis seems to imply that he
 believes it would be a viable use case (true?)

 I certainly agree that using taxonomies is unrealistic -- things are then
 broken, slow, awkward, etc. Then again, any generic posts relationship
 table I can think of would end up looking like:

 - nodes (id, type)
 - node2node (parent, child, type)

 To me, things ought to look like the above in WP, with terms and posts
 getting merged at some point.

 In some respects, it's a horrible idea. But it's also the most generic and
 flexible. And considering the implicit assumption in WP that a DB is a
 gigantic array, I'd say we're heading in that direction anyway.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14513#comment:10>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software