pggen
sq
Our great sponsors
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pggen
-
We Went All in on Sqlc/Pgx for Postgres and Go
If you want a code generator like this that has support for that kind of thing, https://github.com/opendoor/pggen can automatically infer these kinds of relationships based on foreign key relationships and emit slices of pointers to connect the records together in memory. It can even figure out 1-1 relationships if there is a UNIQUE index on the foreign key. There is a little mini-DSL for specifying exactly how much of the transitive closure of a given record you want to get filled in for you.
sq
-
We Went All in on Sqlc/Pgx for Postgres and Go
- generate code from running database and use a type-safe query builder (https://github.com/bokwoon95/go-structured-query)
-
JOOQ library equivalent for Go?
https://github.com/bokwoon95/go-structured-query plugging my library, which was inspired by jOOQ. Do check it out and see if it fits your needs.
-
what's your experience writing sql with go?
I'm a big fan of go-structured-query. I quite like the code generation of tables from a database schema, as well as the core struct mapper feature both for reads/writes to the database, which keep the domain entities clean of any struct tags.
-
I don't want to learn your garbage query language
Interesting. I've been looking at https://github.com/bokwoon95/go-structured-query but I'll have to look at reform too, now. Thanks.
What are some alternatives?
pggen - Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
SqlKata Query Builder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
sqlparser-rs - Extensible SQL Lexer and Parser for Rust
bolt
goqu - SQL builder and query library for golang
pgweb - Cross-platform client for PostgreSQL databases
sqlite
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
gnorm - A database-first code generator for any language
jaeger - CNCF Jaeger, a Distributed Tracing Platform
proteus - A simple tool for generating an application's data access layer.
kingshard - A high-performance MySQL proxy