pggen
A database first code generator focused on postgres (by opendoor)
proteus
A simple tool for generating an application's data access layer. (by jonbodner)
Our great sponsors
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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
Posts with mentions or reviews of pggen.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-09-08.
-
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.
proteus
Posts with mentions or reviews of proteus.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-10-16.
-
ORM vs SQL Builder in Go
I have a SQL mapping tool called Proteus at https://github.com/jonbodner/proteus . I spoke about its design and performance at GopherCon 2017: https://www.youtube.com/watch?v=hz6d7rzqJ6Q
-
We Went All in on Sqlc/Pgx for Postgres and Go
If you are looking for a way to map SQL queries to type safe Go functions, take a look at my library Proteus: https://github.com/jonbodner/proteus
Proteus generates functions at runtime, avoiding code generation. Performance is identical to writing SQL mapping code yourself. I spoke about its implementation at GopherCon 2017: https://www.youtube.com/watch?v=hz6d7rzqJ6Q
What are some alternatives?
When comparing pggen and proteus you can also consider the following projects:
pggen - Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
sqlite
sqlparser-rs - Extensible SQL Lexer and Parser for Rust
gnorm - A database-first code generator for any language
goqu - SQL builder and query library for golang
bazel-postgres-sketch
jet - Type safe SQL builder with code generation and automatic query result data mapping
ccgo
ent - An entity framework for Go