pgx VS migrate

Is it better to use tools like [pgx](https://github.com/jackc/pgx) or stick with a ORM like GORM.

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.

The Wiki doesn't help to get you started?

Regarding postgres setup, it looks ok, I recommend considering pgx instead of libpq; reason being maintainability, libpq even recommends using pgx instead see README.

github.com/jackc/pgx/v4 (v4.17.1)

Is it related to https://github.com/jackc/pgx somehow?

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

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.

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

The tool for migration I use this -> https://github.com/golang-migrate/migrate.

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.

There are other things I generally drag around out of habit like migrate, but I don't necessarily love those as much.

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)

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.

For migrations I use https://github.com/golang-migrate/migrate, it works great

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.