Fork me on GitHub
#sql
<
2019-05-03
>
seancorfield00:05:21

@kenny Are you using deps.edn?

seancorfield00:05:26

I probably ought to cut 0.9.5 of HoneySQL sometime soon... the change list is building up https://github.com/jkk/honeysql/compare/v0.9.4...master

didibus01:05:33

Is there a way for query to return a map where the keys are sorted in the order the select statement had them?

didibus01:05:55

In clojure.java.jdbc

seancorfield03:05:08

@didibus No. You could do it in next.jdbc by writing your own ResultSetBuilder.

seancorfield03:05:24

(sorry, I was off having dinner and didn't see the question until now)

didibus04:05:44

Eh no worries, I had paid commercial support that wasn't this fast so not complaining one bit 😋

seancorfield04:05:53

Happy to walk you through how to do it with next.jdbc. I want to get folks moved to that anyway.

didibus04:05:39

Its okay, I'm too committed to clojure.java.jdbc now 🤤. Also, realized the order should probably be defined in the view anyways.

didibus04:05:32

I know your team likes to be cutting edge on dependencies, but mine it's the other way around hehe

didibus04:05:05

So I'd have to do arguing and all to justify the move to something brand new

seancorfield04:05:10

next.jdbc is the next version of clojure.java.jdbc 🙂

didibus04:05:31

Haha, ya I know. But it is still unstable no?

seancorfield04:05:43

We're using it at work.

seancorfield04:05:06

It is, technically, alpha right now, but I am aggressively aiming for a 1.0.0 release.

seancorfield04:05:53

clojure.java.jdbc is 0.7.9 right now and probably won't get another release at this point, unless there are critical bugs that need fixing.

didibus04:05:59

Hum... ya. I think I'd give it a go when the api stabilizes in the 1.0

didibus04:05:20

Or just leaves alpha

seancorfield04:05:42

OK. The API is stable. The only changes have been in esoteric stuff that @ikitommi wanted.

didibus04:05:07

Mostly because it's a huge pain to import dependencies internally at my work. So I prefer bringing in version that aren't seeing a lot of activity 😋

seancorfield04:05:32

Ah, interesting. OK, fair enough.

didibus04:05:51

I don't know. Maybe I'll give it a quick look if I find some time and see if I can sneak it in. But ya, we can't depend directly on Clojars or Maven. So any external lib I import is just a huge hassle. Goes through license review by legal team and quick security check of the source

didibus04:05:31

Really annoying 😛 🔫

seancorfield04:05:50

The license is EPL 1.0, like Contrib/Clojure. Deliberately.

seancorfield04:05:54

I'd certainly appreciate a security check of the source so... hey, if you could get those wheels rolling, that would be beneficial 🙂

didibus04:05:42

Haha, well clojure.java.jdbc was green

didibus04:05:48

Can tell you that

didibus04:05:10

But I'm pretty sure it just goes through one of the automated byte code checker

didibus04:05:22

So its not the most thorough thing

seancorfield04:05:27

Oh... that's... very corporate 😐

didibus04:05:14

Yup :face_with_hand_over_mouth:

seancorfield04:05:44

I'm kind of amazed you've managed to get Clojure in at all...

didibus04:05:44

Anyways, I'm still looking forward to next.jdbc. it looks really nice. I'll eventually get around to using it

didibus04:05:36

Haha, ya. I maintain all the internal Clojure stuff. It's a pain, but worth it.

seancorfield04:05:01

When I interview with a company, I always make sure they understand that I contribute to OSS, I intend to continue contributing to OSS, and that I will expect at least some work done at/for the company to be OSS.

seancorfield04:05:53

I've had it written into employment contracts.

seancorfield04:05:05

Years ago (ahem, decades ago), I worked for a firm of actuaries where we couldn't install anything on our machines. When support came to install something on my colleague's machine next to me, I had already put in a ticket for the same software and suggested that they pass the disks to me and we install it on both machines at the same time. Nope. They put each disk back into their secure briefcase as they used it, and they would come out later to install the same software on my machine. Argh! I lasted five months.

didibus04:05:05

Haha, awful. That's a good idea though to ask for it upfront on the employment contract.

didibus04:05:54

I'll keep that in mind