Clojurians Log v2

mng

Good morning.

Yesterday at the dojo we found annoying the fact that Korma wouldn’t accept a database uri so I fixed that today: https://github.com/korma/Korma/pull/316

And the Korma Luminus integration we coded mostly yesterday at the dojo: https://github.com/luminus-framework/luminus-template/pull/137

Morning

Hi @thomas.

mawnink

korma, i remember you, and clojureql too, i had such high hopes

honeysql was ok when query composition was required, but i ended up mostly using java.jdbc and << string splicing

though if i'd been taking input from the web to make queries with, a lib which took care of quoting would have been a good idea

mccraigmccraig: maybe you’d like yesql.

pupeno: yeah, probably... i would give it a go if i was doing any web-facing sql atm

It feels like Korma and pals are repeating the mistakes of other languages, trying to build an “ORM” when what I mostly want is a way to cleanly hook up SQL/JDBC to my objects.

In Java-land I’ve had projects that were very successful that just used a low-level JDBCTemplate and hand-rolled SQL. And projects that were painful that used Hibernate and other magic to generate queries for me, usually badly and in unreadable ways.

We have a DSL for talking to databases - it’s called “SQL”. :simple_smile:

anyone here got anything to say about https://github.com/juxt/yada ? it looks great ...

The problem with SQL is that it’s not composable

Korma and others try to fix that

I still prefer building up pure SQL

layers on top don’t help

honeysql did the best job at query composition of any of the clj sql libs i've tried

@mccraigmccraig: I haven't used yada myself yet, but had a chat with Malcolm about it and it does sound very positive indeed

it addresses some of the problems that were found in liberator

i'm just putting a new api together, and yada seems to hit everything i want... mostly async with aleph / manifold, swagger and schema validations