Scuttle – SQL and Arel Editor • Hacker News Board

Re: Scuttle – SQL and Arel Editor

#11

Post by Nullabillity » Mon, May 12, 2014, 1:50 PM UTC

pilif wrote: post #3

I'm probably totally old-fashioned and crazy, but I personally think the SQL code is much more readable and understandable than the arel code that's generated. Why does everybody hate SQL so much that they have to invent their own query language which will eventually evolve to have the same capabilities as SQL but which will look differently, and will be specific to a host language? Sure. There's the issue of SQL inj…

Working with strings as code causes editors to get confused, is hard to compose, and means you lose out on any kind of static analysis.

Re: Scuttle – SQL and Arel Editor

#12

Post by yxhuvud » Mon, May 12, 2014, 1:53 PM UTC

emiller829 wrote: post #6

Hi all. Arel committer here. This is a very cool application, and I really enjoyed attending (and helping answer questions) at Cameron's RailsConf talk. That being said, I've become increasingly convinced that constructing queries with Arel is a fun exercise, but ultimately not terribly worthwhile for those of us who are just writing applications. There are three reasons I can think of that people write their queries…

4: Generating queries that are composable with other queries.

Re: Scuttle – SQL and Arel Editor

#13

Post by justplay » Mon, May 12, 2014, 1:56 PM UTC

awesome. I have been waiting for this.

Re: Scuttle – SQL and Arel Editor

#14

Post by emiller829 » Mon, May 12, 2014, 2:33 PM UTC

yxhuvud wrote: post #12

emiller829 wrote: post #6

Hi all. Arel committer here. This is a very cool application, and I really enjoyed attending (and helping answer questions) at Cameron's RailsConf talk. That being said, I've become increasingly convinced that constructing queries with Arel is a fun exercise, but ultimately not terribly worthwhile for those of us who are just writing applications. There are three reasons I can think of that people write their queries…

4: Generating queries that are composable with other queries.

If you really must have this, you can get it already with Relation#merge. If you're just referring to using one query as a subquery in another, this is available in ActiveRecord directly without needing to drop to Arel. In fact, unless you're meaning something very different than what I am interpreting, there's nothing Arel's buying you over ActiveRecord::Relation in this regard.

Re: Scuttle – SQL and Arel Editor

#15

Post by emiller829 » Mon, May 12, 2014, 2:34 PM UTC

sudhirj wrote: post #9

sudhirj wrote: post #8

Earlier quoted context omitted.

Is there any way to use the OR clause in a Rails SQL query without dropping down to Arel? Can't seem to find a way.

Programatically, I mean. For instance, I can call `where` multiple times in a loop to chain AND clauses.

Not chainably, out of the box, though you can abuse build_where to do this and join with strings easily enough.

Re: Scuttle – SQL and Arel Editor

#16

Post by yebyen » Mon, May 12, 2014, 5:09 PM UTC

ozh wrote: post #5

(Not the best name maybe, there's a long established OSS project named Scuttle already)

I think you're referring to the Delicious-style "web bookmarks manager" clone -- it has forks like SemanticScuttle as well, I agree, the name is taken. Came here to say this.