Re:Everything that makes working with databases easier
by jchw on Sunday May 29, 2022 @12:18PM
(#31550314)
Would sqlc.dev fit here? It is now one of my favorite database-related codegen tools.
[ Parent
| on HN ]
Re:Everything that makes working with databases easier
by mutant on Sunday May 29, 2022 @12:25PM
(#31550367)
> Would sqlc.dev fit here? It is now one of my favorite database-related codegen tools.
So this scaffolds sql queries? That's pretty cool
Re:Everything that makes working with databases easier
by enobrev on Sunday May 29, 2022 @01:10PM
(#31550758)
This is excellent. I had just very recently thought to build this same thing for php and typescript. Haven't started it yet, but great to see the same thing out there for other languages.
Re:Everything that makes working with databases easier
by jchw on Sunday May 29, 2022 @04:21PM
(#31552533)
If you don’t mind the codegen being written in Go, it does look like these folks also want to do the same thing for TypeScript.
https://github.com/kyleconroy/sqlc/issues/296
Given the success of packaging other Go and Rust tools into npm, like esbuild, I suspect it’s probably actually not too bad of an idea.
Re:Everything that makes working with databases easier
by teddyh on Sunday May 29, 2022 @01:54PM
(#31551148)
sqlc generates Go code, nothing else, but the web page of sqlc.dev does not mention this anywhere. Of course, this is a .dev site, and .dev is owned by Google, so it is only to be expected, I guess?
Re:Everything that makes working with databases easier
by jchw on Sunday May 29, 2022 @04:17PM
(#31552492)
It is Go first and foremost, but there are work-in-progress generators for other languages, including Kotlin and (in my opinion, somewhat oddly,) Python.
https://docs.sqlc.dev/en/latest/reference/language-support.h...
It also only supports PostgreSQL as a first class option. It’s still maturing. That said, I’m using PostgreSQL + Go in production with no qualms.