pgx
PostgreSQL driver and toolkit for Go (by jackc)
pq
Pure Go Postgres driver for database/sql (by lib)
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.
pgx
Posts with mentions or reviews of pgx.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-12-18.
-
Can anyone help me on how you are using golang with databases in production systems?
Is it better to use tools like [pgx](https://github.com/jackc/pgx) or stick with a ORM like GORM.
- One Million Database Connections
- Go and PostgreSQL
-
Dapper-like ORM, Mapping
If your schema/migrations are not part of the go project then it might not be a great fit. It does support pgx which is a huge advantage imo vs plain database/sql.
-
Looking for some PgSQL infos
The Wiki doesn't help to get you started?
-
Is this a proper setup in Go for a postgres api?
Regarding postgres setup, it looks ok, I recommend considering pgx instead of libpq; reason being maintainability, libpq even recommends using pgx instead see README.
-
Building a Simple TODO App with Gin-gonic in Zerops: A step-by-step Guide
github.com/jackc/pgx/v4 (v4.17.1)
-
pgx is awesome: introducing pg_idkit
Is it related to https://github.com/jackc/pgx somehow?
-
Go EventSourcing and CQRS with PostgreSQL, Kafka, MongoDB and ElasticSearch 👋✨💫
PostgeSQL as event store database Kafka as messages broker gRPC Go implementation of gRPC Jaeger open source, end-to-end distributed tracing Prometheus monitoring and alerting Grafana for to compose observability dashboards with everything from Prometheus MongoDB MongoDB database Elasticsearch Elasticsearch client for Go. Echo web framework Kibana Kibana is data visualization dashboard software for Elasticsearch Migrate for migrations
-
How learn backend for frontend dev?
I'd stick with this approach rather than trying to learn Gorm as well. Simple is really your friend at this point. Note that because you aren't using Gorm you will need some other way of creating your tables. The simplest way of doing this is just to execute SQL table creation DDL statements manually using `psql`. There are separate migration packages for Go, but all that can come later I think. Note also that the old `pq` driver for Postgres is in maintenance mode, so maybe look at https://github.com/jackc/pgx which seems to be the recommended way of connecting to Postgres going forward.
pq
Posts with mentions or reviews of pq.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-12-31.
- Ask HN: Slimvoice Alternative?
- Fly.io and Tailscale Saved Notado
- Restful API with Golang practical approach
-
Connect REST API to database with Go
Go’s standard library was not built to include any specific database drivers. So we need to install a third party package. In this case we are going to install https://github.com/lib/pq. Run following command:
-
Getting EOF when connecting to a database using sqlx
For Postgres the driver comes from "github.com/lib/pq" and then it is just "postgres".
-
Is this a proper setup in Go for a postgres api?
With regards to 2. -- also, it looks like there's an important unfixed issue https://github.com/lib/pq/issues/939. I haven't verified whether the issue is up to date.
-
Connect to postgres database using connection string?
Postgres (pure Go): https://github.com/lib/pq [*]Postgres (uses cgo): https://github.com/jbarham/gopgsqldriver Postgres (pure Go): https://github.com/jackc/pgx [*]
-
Golang future web frameworks!
lib/pq 7.3k Stars, Used by 63k
-
psql driver that supports the sql.NamedArgs & sql.Named?
I am using the lib/pq driver. is there a driver that does allow for this syntax or is there something I can change?
- Why all the hate?
What are some alternatives?
When comparing pgx and pq you can also consider the following projects:
sqlx - general purpose extensions to golang's database/sql
GORM - The fantastic ORM library for Golang, aims to be developer friendly
gomock - GoMock is a mocking framework for the Go programming language.
sqlc - Generate type-safe code from SQL
go-sql-driver/mysql - Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package
migrate - Database migrations. CLI and Golang library.
goqu - SQL builder and query library for golang
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.
go-sqlite3 - sqlite3 driver for go using database/sql
retry-go - Simple golang library for retry mechanism