Abstracting Data Query in Ruby with Ambition Ambition
- Share
-
- |
Read later
My Reading List
One of today's challenges is to reduce the complexity of accessing and integrating information from various sources. While .NET already has such LINQ, Ruby had no such solution. There are existing DSL projects for querying with Ruby but not as Ruby.
Chris Wanstrath brings his own solution: Ambition. Ambition takes advantage of ParseTree to walk the parse tree and translate plain Ruby queries into SQL (when the target is a Relational Database), so at the end you'll be able to write your queries the Ruby way:
While originally Chris was gunning for Rack, he changed his target since he discovered LINQ.
2 comments
Chris Wanstrath brings his own solution: Ambition. Ambition takes advantage of ParseTree to walk the parse tree and translate plain Ruby queries into SQL (when the target is a Relational Database), so at the end you'll be able to write your queries the Ruby way:
User.first
# which will translate into "SELECT * FROM users LIMIT 1"
User.select { |u| u.karma > 20 }.sort_by(&:karma).first(5)
# which will translate into "SELECT * FROM users WHERE (users.`karma` > 20)
# ORDER BY users.karma LIMIT 5" While originally Chris was gunning for Rack, he changed his target since he discovered LINQ.
We’ve moved our sights from Rack to LINQ. That is, we don’t want to only support other ORMs—we want Ambition to be a query language for SQL, LDAP, XPath, the works. The 1.0 release will be backend-agnostic. Maybe then we’ll change the name to Hubris? Time will tell.You can find latest sources at
git://errtheblog.com/git/ambition
Community comments
Another Groovy plug :)
by
Thom Nichols
Posted
Re: Another Groovy plug :)
by
Werner Schuster
Posted
Another Groovy plug :)
by
Thom Nichols
GORM does this very well too, although the approach is a bit different. I think I like this syntax better.
At some point GORM will support JPA, which (if I understand correctly) means it should be able to query XML and such as well.
At some point GORM will support JPA, which (if I understand correctly) means it should be able to query XML and such as well.
Re: Another Groovy plug :)
by
Werner Schuster
There might be overlap in the querying features, but not in the approach. Following your link, GORM seems to use Builders or string queries, or something that seems to use the Groovy version of method_missing.
However, Ambition works by actually looking at the AST of the queries, and as such is similar to Macros in languages like LISP or Scheme. The link to LINQ (pun intended) is that LINQ uses the same approach.
Of course, the results of the various solutions are the same, but the approaches are different. Question is how well Ruby syntax lends itself to Macros: the Ambition queries still need to be legal Ruby code, otherwise it couldn't be parsed. This is different in LISP, since there isn't much syntax to speak of in the first place. Of course, taking a peek at LINQ can help here.
However, Ambition works by actually looking at the AST of the queries, and as such is similar to Macros in languages like LISP or Scheme. The link to LINQ (pun intended) is that LINQ uses the same approach.
Of course, the results of the various solutions are the same, but the approaches are different. Question is how well Ruby syntax lends itself to Macros: the Ambition queries still need to be legal Ruby code, otherwise it couldn't be parsed. This is different in LISP, since there isn't much syntax to speak of in the first place. Of course, taking a peek at LINQ can help here.
Educational Content
Writing Usable APIs in Practice
Giovanni Asproni May 19, 2013
Concurrency in Clojure
Stuart Halloway May 17, 2013
Hello stranger!
You need to Register an InfoQ account or Login to post comments. But there's so much more behind being registered.Get the most out of the InfoQ experience.
Tell us what you think