Live data from Hacker News

ClojureQL - 1.0.0 now in beta

bestinclass.dk

21–23 of 23 posts

Re: ClojureQL - 1.0.0 now in beta

#21

MySQL only Which is why I'm still using Oyako ( https://github.com/briancarper/oyako )

A new version of oyako is coming soon-ish (within a week or two) with possible mysql support, but it will always focus primarily on postgresql. The next version will also feature an SQL DSL similar to ClojureQL but less fancy / magical. (ClojureQL looks pretty cool itself though.)

In my brief experience, the idea of a cross-database SQL DSL is a lost cause unless you want to limit yourself to a very small subset of SQL. Funny, for a language that supposedly has a standard.

Re: ClojureQL - 1.0.0 now in beta

#22
post #20

MySQL only Which is why I'm still using Oyako ( https://github.com/briancarper/oyako )

ClojureQL works fine with postgresql or any other database supported by JDBC.

Is there a way to tell it to use different syntax for take/drop for databases (like Sybase) that use the "select top X * from foo" syntax rather than "select * from foo limit X"?

Re: ClojureQL - 1.0.0 now in beta

#23
post #20

Earlier quoted context omitted.

ClojureQL works fine with postgresql or any other database supported by JDBC.

Is there a way to tell it to use different syntax for take/drop for databases (like Sybase) that use the "select top X * from foo" syntax rather than "select * from foo limit X"?

Not yet. Currently we try to follow the SQL standard as closely as possible, but some operations like OFFSET/LIMIT provide challenges.

Would be fun to see if we could do some kind of SQL templating where users could supply their own templates.

Post reply on HN