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

[WordPress Trac]

#12891: Advanced multi-taxonomy WP_Query()s
----------------------------+-----------------------------------------------
 Reporter:  markjaquith     |       Owner:  markjaquith         
     Type:  task (blessed)  |      Status:  assigned            
 Priority:  normal          |   Milestone:  3.1                 
Component:  Query           |     Version:  3.0.1               
 Severity:  normal          |    Keywords:  taxonomies has-patch
----------------------------+-----------------------------------------------
Changes (by mikeschinkel):

 * cc: mikeschinkel@… (added)


Comment:

 Replying to [comment:12 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.

 +1.  I echo filosofo's concerns and really like his suggestions.

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