honeysql

Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
viesti 2020-09-26T07:27:56.055700Z

humdum, looking at honeysql-postgres https://github.com/nilenso/honeysql-postgres#upsert, while trying to figure out if insert into foo select * from .. on conflict ... is supported (sorry the rubber duck babling, hoping that it helps me and doesn't bother other too much :)), would seem that maybe only values lists are supported

seancorfield 2020-09-26T07:30:15.057200Z

@viesti Good timing... I'm working on HoneySQL V2 and I'd like to support that out of the box so feel free to create an issue against HoneySQL with details of what you'd like supported and links to the PG docs if poss and I'll integrate it.

seancorfield 2020-09-26T07:30:49.057900Z

I'll probably integrate all of the non-DDL parts of nilenso/honeysql-postgres in some form...

seancorfield 2020-09-26T07:31:18.058500Z

V2 will support dialects, so having additional clause support like that is very reasonable.

viesti 2020-09-26T07:32:41.058800Z

oh wau, good timing 🙂

viesti 2020-09-26T07:33:48.059400Z

have to go back to vacuuming the house though, I can make the issue after that 🙂

seancorfield 2020-09-26T07:40:13.059600Z

(I'm off to bed so no rush!)

💤 1
viesti 2020-09-26T09:11:35.060600Z

also vacuuming helped, had an extra ! in my (psqlh/do-update-set :value) code, seems the honeysql-postgres support also the insert into with select and conflict