Mark Armendariz wrote:
This might seem completely ridiculous and tear the idea to shreds if
you must, but I've been working on a library with it's own query
language that creates both the SQL and the PHP Objects to reference
everything returned. Though I've been working on it for quite some
time, it's still too early (read: messy) to offer it to the masses
(I'm successfully using it in 4 of my current small to medium sized
projects).
Over the past 10 years, every time I try to keep all my queries in one
place, whether it be with SQL or with some objects representing my
Database Tables, i end up with a bunch of functions named
getCustomers, getCustomer($id), getCustomersInNy,
getCustomersInTristate, so instead I made a language that allows
something like:
I'm really fascinated by ideas like this.
Have you seen HQL, the query language that comes with the
(Java-based) Hibernate ORM system?
http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
