[wp-hackers] Metadata Mess

Jacob Santos wordpress at santosj.name
Tue Dec 22 11:23:42 UTC 2009


I'm not sure what the argument was, but it seems to me that this table 
structure:

id,
object_type
object_id
key_name
key_value

Could easily replace the 3 tables that currently exist. Of course, it 
might seem slow that object_type would be varchar and usually a number 
index will be faster, but at this point, I'll rather go with anything.

Wasn't there a ticket at some point about replacing the tables? Pretty 
sure there was, was there no traction? Was the patch(es) not acceptable? 
Did no one create a patch? Was the API unacceptable? What would make an 
API acceptable?

I think starting simple and then going crazy with the scheme should work 
better, because I don't want to have to defend or explain why there are 
three tables that are same except for where they are joined. Actually, 
my boss would enjoy the wasteful use of duplicate table structures.

Excuse me while I go blow my brains out while screaming obscenities.

Jacob Santos


More information about the wp-hackers mailing list