[wp-trac] [WordPress Trac] #12891: Advanced multi-taxonomy WP_Query()s

WordPress Trac wp-trac at lists.automattic.com
Wed Jul 14 03:21:51 UTC 2010


#12891: Advanced multi-taxonomy WP_Query()s
-----------------------------+----------------------------------------------
 Reporter:  markjaquith      |       Owner:  ryan                
     Type:  feature request  |      Status:  new                 
 Priority:  normal           |   Milestone:  Awaiting Triage     
Component:  Query            |     Version:  3.0                 
 Severity:  normal           |    Keywords:  taxonomies has-patch
-----------------------------+----------------------------------------------

Comment(by filosofo):

 I thought of this ticket while reading
 [http://seldo.com/weblog/2010/07/12/in_defence_of_sql this post], because
 basically what this proposed system attempts to do is put an ORM on top of
 the taxonomy and post database queries.

 One (worthy) goal is obviously to provide an abstraction for complex
 taxonomy queries, an abstraction that's independent of the actual database
 structure.  The problem is that it ends up forcing developers to learn a
 new, custom querying syntax that isn't as powerful as basic SQL.

 I don't have a good solution at this point. Although we don't want to
 expose the actual database structure, I don't think we can get away from
 SQL-like syntax because it's really the most familiar and appropriate tool
 for the job.

 Facebook Query Language (FQL) is an example of how you can expose an SQL-
 like API, so perhaps like it we could offer a few reduced SELECT query
 patterns that are trivial to parse.  The idea would be that it is a syntax
 already known to those who need to make the complex queries in the first
 place, but yet a syntax not coupled to the actual, current database
 structure.

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


More information about the wp-trac mailing list