Re:Ask HN: What are some tools / libraries you built yourself?
by newusertoday on Monday May 17, 2021 @02:05PM
(#27186254)
can you give more details, i am generating golang and js functions corresponding to plpgsql functions in somewhat hacky way. I am curious to know what approach have you taken, is it something similar to this project https://github.com/gchaincl/dotsql
Re:Ask HN: What are some tools / libraries you built yourself?
by doctor_eval on Thursday May 20, 2021 @08:12AM
(#27220121)
hey sorry i didn't see this earlier. it's not a code generator, as such, it's really just a structured way to write PLPGSQL functions alongside Go code, and have it deployed and upgraded automagically.
It would be great to generate Go stubs from the SQL definitions and I don't do that. I'd like something a bit like dotsql but ideally where it creates actual Go funcs out of the SQL function signatures.
The bit that I've done so far lets you package up SQL functions into a schema and treat them as a Go package. you can include them in go.mod and the functions are maintained without writing migration scripts.
I'm under the pump at the moment but I'll try to write something up about it and maybe ping you on github some time. Sorry i don't have much time at the moment!
Re:Ask HN: What are some tools / libraries you built yourself?
by danielheath on Sunday May 16, 2021 @06:59PM
(#27177956)
I definitely want something like that.
I’ve used it very successfully in production for a few years and have been curious if anyone else would find it useful enough for me to open it up.