3 ms·

Thanks! I love the concept of sqlc, but their support for pgx with its native PostgreSQL interface was quite limited when I checked. I imagine it's better nowad

by henvic 5y ago

Thanks! I love the concept of sqlc, but their support for pgx with its native PostgreSQL interface was quite limited when I checked. I imagine it's better nowadays, and will try again soon!

lonk11 5y ago
The support for native pgx in sqlc is good now. I migrated my project from database/sql to pgx recently and posted the instructions at the end of this post: https://linklonk.com/item/1948319982853095424 https://linklonk.com/item/1948319982853095424
sa46 5y ago
You might like pggen (I’m the author) which only supports Postgres and pgx. https://github.com/jschaf/pggen https://github.com/jschaf/pggen pggen occupies the same design space as sqlc but the implementations are quite different. Sqlc figures out the query types using type inference in Go which is nice because you don’t need Postgres at build time. Pggen asks Postgres what the query types are which is nice because it works with any extensions and arbitrarily complex queries.
- henvic 5y ago
  Thank you. I'll take a look in the upcoming weeks. It seems promising!