ozzo-dbx
A Go (golang) package that enhances the standard database/sql package by providing powerful data retrieval methods as well as DB-agnostic query building capabilities. (by go-ozzo)
go-pg
Golang ORM with focus on PostgreSQL features and performance (by go-pg)
| ozzo-dbx | go-pg | |
|---|---|---|
| 1 | 9 | |
| 623 | 5,586 | |
| 0.5% | 0.4% | |
| 0.0 | 6.4 | |
| about 1 year ago | 6 days ago | |
| Go | Go | |
| MIT License | BSD 2-clause "Simplified" 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.
ozzo-dbx
Posts with mentions or reviews of ozzo-dbx.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-07-02.
-
What SQL library are you using?
If you are looking for a query builder only, I also could recommend https://github.com/go-ozzo/ozzo-dbx (it doesn't seem to be maintained but its stable and so far I haven't stumbled on a bug using it for an internal tool)
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
What are some alternatives?
When comparing ozzo-dbx and go-pg you can also consider the following projects:
kingshard - A high-performance MySQL proxy
GORM - The fantastic ORM library for Golang, aims to be developer friendly
sqrl - Fluent SQL generation for golang
bun - Incredibly fast JavaScript runtime, bundler, test runner, and package manager – all in one
go-mysql - a powerful mysql toolset with Go
ent - An entity framework for Go
pREST - PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new
SQLBoiler - Generate a Go ORM tailored to your database schema.
prometheus - The Prometheus monitoring system and time series database.
sqlx - general purpose extensions to golang's database/sql
gormigrate - Minimalistic database migration helper for Gorm ORM
bun - SQL-first Golang ORM