go-pg
Golang ORM with focus on PostgreSQL features and performance (by go-pg)
sqlf
sqlf generates parameterized SQL statements in Go, sprintf style (by keegancsmith)
| go-pg | sqlf | |
|---|---|---|
| 9 | 5 | |
| 5,586 | 126 | |
| 0.3% | - | |
| 6.4 | 3.0 | |
| 4 days ago | 9 months ago | |
| Go | Go | |
| BSD 2-clause "Simplified" License | MIT License |
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
sqlf
Posts with mentions or reviews of sqlf.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-07-20.
-
What’s your preferred setup to work with SQL DB (without ORM) ?
sqlf for building parameterized queries, yet to settle on a row-to-struct mapper, doing it manually for now
- What SQL library are you using?
-
Looking for some ORM/db access layer suggestions
We use https://github.com/keegancsmith/sqlf at work for building queries, its very enjoyable. It feels like using fmt.Sprintf but everything is properly parameterized
-
Do you think building SQL Queries like strings.Builder{}/fmt.Printf is practical and readable?
Oh. I meant this one https://github.com/keegancsmith/sqlf
-
What are your favorite packages to use?
https://github.com/keegancsmith/sqlf for building parameterized SQL queries
What are some alternatives?
When comparing go-pg and sqlf you can also consider the following projects:
GORM - The fantastic ORM library for Golang, aims to be developer friendly
bun - SQL-first Golang ORM
bun - Incredibly fast JavaScript runtime, bundler, test runner, and package manager – all in one
pgx - PostgreSQL driver and toolkit for Go
ent - An entity framework for Go
ginkgo - A Modern Testing Framework for Go
SQLBoiler - Generate a Go ORM tailored to your database schema.
godotenv - A Go port of Ruby's dotenv library (Loads environment variables from .env files)
sqlx - general purpose extensions to golang's database/sql
Gin - Gin is a HTTP web framework written in Go (Golang). It features a Martini-like API with much better performance -- up to 40 times faster. If you need smashing performance, get yourself some Gin.