Good morning!

Good morning Joost.

Good morning all

Good morning! What are you all up to today?

Working on upgading a big monolitic java cms, but from home, so I probably have time to setup the micro clojure cms so my girlfriend can start creating content for the cattery.

mogge

I got my day off today!!! Busy scanning old negatives

I’m debugging sql/clojure performance issues. ⌨️

Lol I think I should look at the clock on my VPS

I think it’s nice, I played a little with it, but it’s a much easier setup then cucumber with selenium, and using macros you could easily create something to write ‘readable’ tests if you want to

@joost-diepenmaat what clj sql lib do you use? We write pure sql queries using hugsql

+1 for hugsql, very nice library

We also have a reducible thing for processing rows using transducers, for giant ass results.

I only used alaisi/postgres.async following a graphql example, left me stuck at about 500 ‘operations’ a second, might rewrite to hugsql to see if it increases performance.

downside of hugsql I found were the macros

oksql addresses this and some other issues: https://github.com/swlkr/oksql#why

We’re using honeysql mostly. It’s the easiest way to generate dynamic queries.

Anyone experience using just https://github.com/clojure/java.jdbc ?

@gklijs I’ve done that for a while. Works great, but it’s nice to edit sql in a .sql file and not having it as an inline string.

@eval2020 definitely gonna give oksql a try soon, looks nice

we haven’t run into the validation issue that the README mentions with hugsql: just call the generated function, no problem

I also wonder if it supports the host of features that hugsql provides

oksql looks interesting! is it a bit popular @eval2020 ?

i do like the idea of hugsql, but i am a bit allergic towards macros

also, don't use postgresql.async, it's a farce -- they just all do thread-per-connection in the background + a lot of multiplexing, i haven't found any big advantage to that myself

well, if I have to choose between macros or code generation (as in spitting out files), I choose macros 🙂 there’s only one macro in hugsql you use to go from .sql to defining query functions. no magic, that’s fine with me for now.

@lmergen I just copied bits and pieces from the lacinia manual, only a bit later the writer admitted it was just added to the tutorial as example, and that he himself did not had much experience using clojure with sql (they use something else at Walmart).

@lmergen almost 50 stars (first commit in oct 2017)… I thought it was anounced on Reddit - but searching fails me…owell, reddit-search… 😉

@gklijs right, well i would definitely just use clojure.java.jdbc, it's pretty much compatible with everything else out there

i.e. you can at a later point easily transition to some SQL wrapping library, and it will most likely still spit out sqlvecs that you can feed to java.jdbc

this is what hugsql also can do: produce sqlvecs you can use in java.jdbc, aside from producing functions you can call (without directly using java.jdbc)