[wp-trac] Re: [WordPress Trac] #5183: General Meta-Data Table

[WordPress Trac]

#5183: General Meta-Data Table
-----------------------------------------+----------------------------------
 Reporter:  filosofo                     |        Owner:  anonymous     
     Type:  enhancement                  |       Status:  reopened      
 Priority:  normal                       |    Milestone:  Future Release
Component:  General                      |      Version:  2.9           
 Severity:  normal                       |   Resolution:                
 Keywords:  needs-patch meta-table meta  |  
-----------------------------------------+----------------------------------

Comment(by mikeschinkel):

 Replying to [comment:38 Denis-de-Bernardy]:

 Ah, good point!  While I am aware of some of the really nasty code in some
 even popular plugins I wasn't thinking about it above; I was instead
 thinking about how people who have some idea how to properly use a SQL
 database would implement.

 One example to support your comments is a very popular plugin that stored
 relationships that should have been in a linking table in a serialized
 array in one of the two tables making certain queries that I needed to run
 impossible in SQL and for performance reasons impractical in PHP.  I won't
 name it here but that plugin is very well-known.

 I do, however, don't think these people misusing tables should be an
 argument against edge-cases using composite keys; instead I think it
 argues *for* it because if we don't give them the ability they will do
 much worse with their own designs.

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