go-pg
Golang ORM with focus on PostgreSQL features and performance (by go-pg)
jet
Type safe SQL builder with code generation and automatic query result data mapping (by go-jet)
| go-pg | jet | |
|---|---|---|
| 9 | 26 | |
| 5,586 | 2,025 | |
| 0.3% | - | |
| 6.4 | 8.1 | |
| 4 days ago | 19 days ago | |
| Go | Go | |
| BSD 2-clause "Simplified" License | Apache License 2.0 |
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.
go-pg
Posts with mentions or reviews of go-pg.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-02-12.
-
Dockerized RESTful API Application in Go: CRUD,ORM,Logs,Migrations,Validations
Might have been this one but I can't be sure https://github.com/go-pg/pg
-
What SQL library are you using?
I usually work with PostgreSQL and have used https://github.com/go-pg/pg. https://github.com/uptrace/bun is its successor.
- Why all the hate?
-
Clean Transactions in Golang Hexagon
And it is go-pg. I personally really like it as a query builder (rather than an ORM) and it has good performance. It has one feature which I'll tell you about next, without which I would have struggled to implement what I had in mind. But this feature is available in other libraries too, so don't rush to rewrite your code.
-
SQL Query Strategy for complex structs
bun and go-pg both seem to work fairly well for these kind of purposes.
- Go for Backend development
-
Connecting with database
For database communication we will use go-pg module. You can install it by running go get github.com/go-pg/pg/v10. This will install version 10 of go-pg module, which is latest version at the time of writing this guide. Now create new directory internal/database/ and file database.go inside of it.
-
How much do you agree completely switching from Java to Go? I have total 9yrs of experience in Java but now I am interested in Go.
gorm.io/gorm`, or `github.com/go-pg/pg` if you need something more feature-rich. I would avoid using `go-kit` and `go-micro` "frameworks" unless you have some special requirement for it. But you can take a look to have an idea of what Go "framework" may look like.
-
A Proposal for Adding Generics to Go
This one is mostly excellent: https://github.com/go-pg/pg
jet
Posts with mentions or reviews of jet.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-09-02.
-
Open-sourcing SQX, a way to build flexible database models in Go
We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.
https://github.com/go-jet/jet
-
The "preferred" way of mapping SQL results in Golang is honestly, subjectively, awful, how to deal with this
Check go-jet https://github.com/go-jet/jet
- Comparing database/sql, GORM, sqlx, and sqlc
-
goscanql - conveniently reading joined SQL data into structs
https://github.com/go-jet/jet does a similar thing.
-
Does Go, has something similar to Laravel eloquent (ORM) ?
Try go-jet, it generates the models based on the schema, provides typed column names.
-
Any mid sized / big open source code base in golang that makes use of SQL DBs?
I have tried doing that, but was unable to get it to work. I posted about it in a discussion here: https://github.com/go-jet/jet/discussions/215
-
Automatic CRUD code generetor?
Jet might be what you're looking for - https://github.com/go-jet/jet
- How to Work with SQL Databases in Go
-
ORM or no ORM (and which ones)?
Use sql builder https://github.com/go-jet/jet.
- GitHub - go-jet/jet: Type safe SQL builder with code generation and automatic query result data mapping
What are some alternatives?
When comparing go-pg and jet you can also consider the following projects:
GORM - The fantastic ORM library for Golang, aims to be developer friendly
sqlc - Generate type-safe code from SQL
bun - Incredibly fast JavaScript runtime, bundler, test runner, and package manager – all in one
goqu - SQL builder and query library for golang
ent - An entity framework for Go
SQLBoiler - Generate a Go ORM tailored to your database schema.
migrate - Database migrations. CLI and Golang library.
sqlx - general purpose extensions to golang's database/sql
pgcapture - A scalable Netflix DBLog implementation for PostgreSQL
bun - SQL-first Golang ORM
go-queryset - 100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.