[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:  Future Release
Component:  Post Types       |      Version:  3.0.1         
 Severity:  normal           |   Resolution:                
 Keywords:                   |  
-----------------------------+----------------------------------------------

Comment(by Denis-de-Bernardy):

 Replying to [comment:15 jane]:
 > @Mike. Get a good plugin out there that makes the table you want, see
 how many people adopt it.

 Doing so is somewhat nonsensical in this particular instance. No plugin
 dev in his right mind would use (let alone search for) a plugin that adds
 an extra table to WP in order to write his own plugin.

 What he'll do instead is use dbDelta and create the table himself. (If
 only to spare his user base the hassle of needing to install two plugins
 in order to implement whatever he's coding.)

 FWIW, I can vaguely picture two approaches for n-n post2post relationships
 in WP:

  * Storing the post_meta table. It won't scale much and, as a cursory look
 at support threads of scribu's plugin reveal, this results in poor
 reciprocal relationship management.
  * The taxonomy API, as in mapping each post to a term and then creating
 term2post relationships (a bit like we do with menus). But I've my doubts
 that the menus API can handle more than a hundred dozen menu items.

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