How We Went All In on sqlc/pgx for Postgres and Go

Re:How We Went All In on sqlc/pgx for Postgres and Go by xorcist on Thursday September 09, 2021 @06:10AM (#28468107)

It does indeed look promising!

Can it help with migrations? Seeing it has the field definitions right there it should at least be possible.

Otherwise I can see how a system like this could become quite complex over time as the database structure changes.

[ Parent | on HN ]

Re:How We Went All In on sqlc/pgx for Postgres and Go by Cthulhu_ on Thursday September 09, 2021 @07:37AM (#28468562)

Based on just this article, it looks like it needs a complete table definition to work with. Unless it queries the database for the definitive schema, but that would mean you need a database up and running at compile time.

[ Parent | on HN ]

Re:How We Went All In on sqlc/pgx for Postgres and Go by xorcist on Thursday September 09, 2021 @10:13AM (#28469906)

I took for granted that sqlc could run all these CREATE TABLEs for you, perhaps that's not the case. It probably should, shouldn't it?

[ Parent | on HN ]