[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