[wp-hackers] Time for a wp_post_relationships table?

[Otto]

This seems like something you could just use meta tables for. Not sure
why this needs a whole other table.

-Otto



On Mon, Aug 2, 2010 at 7:16 PM, Mike Schinkel
<mikeschinkel at newclarity.net> wrote:
> Hi all,
>
> Is it time to discuss a wp_post_relationships table?   Michael Pretty made some rather insightful remarks[1] on the topic last week and I've been bumping into the same:
>
> On Jul 26, 2010, at 10:30 PM, Michael Pretty wrote:
>> We have a couple more projects lined up where we need a many to many relationship between objects and have decided that for us the best option is to bite the bullet and create a new table.  Its something we usually leave as a last resort, but at this point, that seems like the best option because of the issues you mentioned.  I haven't yet worked out all the details of how it is going to work other than a table that stores parent_id, child_id and relationship_type, with lots of caching.  At this point it just seems like it is going to be the only way to provide the many to many relationship that is both stable and provides decent performance.
>
> So I submitted a "straw-man proposal"[2] as a ticket on trac[3].
>
> If you are interested in discussing it, PLEASE let's do it on the trac ticket[3].
>
> -Mike
>
> [1] http://lists.automattic.com/pipermail/wp-hackers/2010-July/033510.html
> [2] http://en.wikipedia.org/wiki/Straw_man_proposal
> [3] http://core.trac.wordpress.org/ticket/14513
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>