pgx VS Gin

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.

Disclaimer: I'm not a frontend dev, I'm not a mobile app coder and I didn't really want to do anything. But I happen to code fairly often in Go, and so I figured the type table was really just a big map of values (either 0, 0.5, 1 or 2) tying one type to all other types... Could I maybe get away with a backend app that would handle it? Surely not... But I had recently noticed the Gin HTTP framework and it seemed fairly easy to use.

gin-gonic/gin

Web framework gin

A lot of places seem to suggest https://github.com/gin-gonic/gin , but it seems too micro for my tastes. There's https://github.com/gobuffalo/buffalo that seems to have the appropriate amount of kitchen sinks included, but does it pass the popularity test? Any other options I've missed?

Gin

I started my project with developing API server in Golang. For the HTTP library I used Gin framework, as it provides an friendly interface to build REST ready API.

Gin is a popular library that claims to use zero heap allocation, for instance.

GoLang Gin Server to create tasks apis