honeysql

Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
dominicm 2020-12-08T12:08:22.220600Z

v2 feedback, would be nice to add custom alternatives to "NOWAIT". I want to add postgres's "SKIP LOCKED".

dominicm 2020-12-08T12:47:10.220700Z

How can I do ORDER BY x is not null?

seancorfield 2020-12-08T16:43:11.221400Z

@dominicm The latter just came up here https://github.com/seancorfield/honeysql/issues/285 (v2 makes this easier than v1 but it's possible in both).

seancorfield 2020-12-08T16:47:10.221800Z

and I created https://github.com/seancorfield/honeysql/issues/286 for your other issue https://github.com/seancorfield/honeysql/issues/286

dominicm 2020-12-08T16:48:50.222Z

Calling :=... weird, but it kinda makes sense if I squint :p.

seancorfield 2020-12-08T16:50:18.222200Z

There's an :is-not operator if you prefer 🙂

dominicm 2020-12-08T16:55:21.222400Z

I think it just violates my expectations based on what works in :where

dominicm 2020-12-08T16:55:39.222600Z

I can see you're aware of that for honeysqlv2 though

dominicm 2020-12-08T16:55:57.222800Z

I'm quite excited to try and write postgres-honeysql2 :)

dominicm 2020-12-08T16:56:04.223Z

(or maybe it won't be needed)

seancorfield 2020-12-08T17:11:11.223200Z

It shouldn't be needed since I plan to add all of PG to HoneySQL directly, over time anyway. Even if some of it has to go into a :postgresql dialect (v2 has dialect support builtin).