Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-27 Thread Kevin Downey
that is very interesting, I've played around with generating sql from datalog queries, but stopped when I ran up against generating queries for recursive datalog rules because I wasn't aware of WITH RECURSIVE On Tue, Jun 26, 2012 at 6:29 PM, Chas Emerick wrote: > Random thought: recursive queries

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-26 Thread Chas Emerick
Random thought: recursive queries are possible in SQL using recursive common table expressions. The PostgreSQL manual has a good introduction to them: http://www.postgresql.org/docs/9.1/static/queries-with.html And another introduction to them, in the particular area of querying hierarchical d

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-26 Thread Niels van Klaveren
Yeah, it's a pain to include Datomic's Datalog implementation through Maven dependencies, since you need to install the jar by hand. Afaik clojure.contrib.datalog didn't compile to SQL. Theoretically it should be possible to do so, since Datalog is a superset of SQL. However, the extra function

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-26 Thread mnicky
Thanks! However it'd be nice if it was released as a separate library. Also, I thought that clojure.contrib.datalog worked for SQL queries... That would be even better ;) On Monday, June 25, 2012 1:50:19 PM UTC+2, Niels van Klaveren wrote: > > You can use the Datomic datalog implementation to qu

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-25 Thread Niels van Klaveren
You can use the Datomic datalog implementation to query Clojure collections. I think this is the same use clojure.contrib.datalog had. On Monday, June 25, 2012 12:47:29 PM UTC+2, mnicky wrote: > > > > On Saturday, June 23, 2012 1:20:30 AM UTC+2, Niels van Klavere

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-25 Thread mnicky
On Saturday, June 23, 2012 1:20:30 AM UTC+2, Niels van Klaveren wrote: > > > I was thinking if an SQL generation DSL / library could be based on > core.logic ? > > Something like revival of clojure.contrib.datalog would be great. -- You received this message because you are subscribed to

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-23 Thread Vinzent
> > Our web stack is built on small libraries building on eachother's > strengths, could we do the same here ? > Yeah, that's exactly what I had in mind. Just like Ring, c.j.jdbc could accept maps and generate corresponding sql code, thus eliminating the need to write a compiler for each sql D

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-22 Thread Niels van Klaveren
I also can't help but think this is overlapping with ClojureQL/Korma. Korma also isn't that far from the 'metal' this library is shooting for. The biggest problem with SQL is that it isn't functionally composeable. Otherwise why use a DSL instead of SQL itself ? It seems a pretty well-designed

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-22 Thread Sean Corfield
On Fri, Jun 22, 2012 at 1:50 AM, Vinzent wrote: > Ok, I see. I've misunderstood the goals. Though, it still duplicates > significant part of clojureql\korma, right? Hmm, I wouldn't say a "significant" part. I think jsql covers a very small space. To satisfy the basic goal for the new c.j.jdbc API

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-22 Thread Vinzent
> > given java.jdbc's position as the sort of lower level glue all these > libraries are built on, maybe better then including a DSL in java.jdbc > would be including an AST (some data representation of sql) and a > compiler for same. > Yeah, that's exactly what I wanted to suggest too. Seems

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-21 Thread Kevin Downey
On Thu, Jun 21, 2012 at 9:33 AM, Sean Corfield wrote: > On Thu, Jun 21, 2012 at 12:33 AM, Vinzent wrote: >> Actually, jsql looks very much like clojureql\korma. > > jsql has completely different goals to ClojureQL/Korma and is mostly a > convenience for generating the sort of SQL that the update!

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-21 Thread Sean Corfield
On Thu, Jun 21, 2012 at 12:33 AM, Vinzent wrote: > Actually, jsql looks very much like clojureql\korma. jsql has completely different goals to ClojureQL/Korma and is mostly a convenience for generating the sort of SQL that the update!, insert! and delete! methods need under the hood (c.j.jdbc has

Re: [ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-21 Thread Vinzent
Actually, jsql looks very much like clojureql\korma. Honetly, I wish see better support for clojureql rather than new similar DSLs coming up. четверг, 21 июня 2012 г., 11:36:24 UTC+6 пользователь Sean Corfield написал: > > Just two changes in this release: > > * as-str now treats a.b as two iden

[ANN] clojure.java.jdbc 0.2.3 available on Maven Central

2012-06-20 Thread Sean Corfield
Just two changes in this release: * as-str now treats a.b as two identifiers separated by . so quoting produces [a].[b] instead of [a.b] This was a bug that I'm kind of surprised no one had tripped over yet. I fell over it as soon as I tried to build a DSL on top of the library. * Add :connectio