[wp-hackers] Custom list of posts per user

Mike Schinkel mikeschinkel at newclarity.net
Wed Sep 15 10:39:43 UTC 2010


On Sep 15, 2010, at 6:32 AM, scribu wrote:
> On Wed, Sep 15, 2010 at 2:10 AM, Mike Schinkel
> <mikeschinkel at newclarity.net>wrote:
>> One option I'm sure you've considered is to add an array value to
>> wp_postmeta.  Of course that is relationally horrible and you can't run JOIN
>> queries using foreign keys in serialized arrays so I'd hope nobody would do
>> that in a plugin.
> 
> Remember that you can have multiple meta values with the same key, so you
> don't need serialization at all.
> 
> You just have to decide which table makes more sense: postmeta or usermeta.

If it's purpose is to store a bigint foreign key in a longtext field, especially if you might need to index on it, I'd say neither makes more sense.  JMTCW.

-Mike


More information about the wp-hackers mailing list