Fork me on GitHub
#honeysql
<
2021-06-17
>
pinealan05:06:05

Is it possible to create VALUES in FROM for postgresql in honeysql 1.x (or 2)?

pinealan05:06:08

ah nevermind scratch that, I realised it’s an issue with values in from requiring an alias, got what I wanted with

(sql/format {:select [[:column1 :num]]
             :from [[{:values [[1] [2] [3]]} :vraw]]})

2
orestis15:06:31

Migrating our codebase to honeysql v2. An easy transition but I’m glad that we have end-to-end tests. If we had a bigger codebase I’d investigate an automated approach with rewrite-clj

orestis15:06:21

Thank you @seancorfield for taking the time to do this work. I particularly like some error messages that I saw!

2
seancorfield16:06:17

We’re migrating one query at a time at work — since we can have both v1 and v2 required into the same namespace.

borkdude16:06:52

I using both (versions of honeysql) at the moment. I just rewrote a query using honeysql which was previously in hugsql... it's way more fun (and easier to debug).

orestis17:06:45

A lot of our queries are interconnected so they have to be changed as a unit. But otherwise we have hugsql, honeysql 1 and honeysql 2 :) We have committed to standardize on honeysql 2 though.

borkdude17:06:49

Where can I get a t-shirt

seancorfield17:06:39

If only HoneySQL had a project logo…

borkdude17:06:57

If you like Calva's and clojure-lsp's logo, you could ask @jayzawrotny

borkdude17:06:36

Nikitonsky designed clj-kondo and babashka's logo, but he's quite busy I think

borkdude17:06:13

@lee also made a few logo's (jet and sci). So there, a few ideas

2
lread18:06:14

I also did rewrite-clj's current logo. It was not terribly imaginative, but I also came up with the clj-kondo icon clj-kondo. Borkdude and I had some fun working out https://github.com/borkdude/sci/issues/129 and https://github.com/borkdude/jet/issues/50 logos. The lil hammock person is from me too: hammock . I would consider myself an amateur, but if you seriously want a logo, and none more talented makes an offer, I could take a stab at it sometime.

2
🙏 2
borkdude18:06:19

The icon is iconic, thanks again @lee

lread18:06:07

For you? Anytime!