pgx
PostgreSQL driver and toolkit for Go (by jackc)
migrate
Database migrations. CLI and Golang library. (by golang-migrate)
Our great sponsors
pgx | migrate | |
---|---|---|
56 | 53 | |
6,581 | 10,705 | |
- | 4.1% | |
6.5 | 7.1 | |
7 days ago | 5 days ago | |
Go | Go | |
MIT License | GNU General Public License v3.0 or later |
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.
migrate
Posts with mentions or reviews of migrate.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-12-25.
-
Managing external database versions in Kubernetes
We use golang-migrate for our platforms and itβs works exceptionally well even when many pods are active. https://github.com/golang-migrate/migrate
-
Can anyone help me on how you are using golang with databases in production systems?
The tool for migration I use this -> https://github.com/golang-migrate/migrate.
-
Create and Seed Your Postgres Database in Minutes with Docker
This involves specifying the schema, which defines the structure and organization of the data, as well as any constraints or rules for the data. To do this we are going to use Go Migrate.
-
Libraries you use most of your projects?
There are other things I generally drag around out of habit like migrate, but I don't necessarily love those as much.
- DB schema management strategy (migrations)
-
Restful API with Golang practical approach
The initial requirement before we start our tutorial is to make sure that you have the following installed setup on your computer: 1) Golang (https://go.dev/doc/install) 2) IDE of your choice VSCode or GoLand JetBrains. 3) Postgresql (https://www.postgresql.org/download/) 4) Insomnia (https://insomnia.rest/) 5) Golang-Migrate (https://github.com/golang-migrate/migrate/blob/master/cmd/migrate/README.md)
-
Language and framework agnostic database migrations.
We use Migrate because Go is our default language in Typeform. The following tutorial could work for any language or framework because the CLI works with SQL files.
-
Which ORM framework are you using with golang, and why?
For migrations I use https://github.com/golang-migrate/migrate, it works great
-
Go Integration Tests using Testcontainers
So far our test starts out with an empty database. That's not very useful since we need the database tables of our application. In our example we need the table users. We will now set up our database using golang-migrate.
- Which ORM do you use in Golang, gorm, xorm,sqlx, bun or sql, is there a recommended scaffold generation code?
What are some alternatives?
When comparing pgx and migrate you can also consider the following projects:
sqlx - general purpose extensions to golang's database/sql
goose
pq - Pure Go Postgres driver for database/sql
GORM - The fantastic ORM library for Golang, aims to be developer friendly
goose - A database migration tool. Supports SQL migrations and Go functions.
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
gormigrate - Minimalistic database migration helper for Gorm ORM
goqu - SQL builder and query library for golang
go-fixtures - Django style fixtures for Golang's excellent built-in database/sql library.