GORM VS go-pg

For more information on Gorm's operation of MySQL, please refer to Gorm

To access PlanetScale, we can use ORM from Go called Gorm, and since the PlanetScale database is built on top Vitess (MySQL), install the MySQL driver as well.

Just my opinion, so it it for what it’s worth to you, but I haven’t been especially impressed with the ORM landscape in Go. I have tinkered with a few ORMs - I gave gorm a serious whirl a few months ago, but ended up ditching it in less than a month. If time is on your side, I’d strongly encourage you to experiment with what the standard library’s database/sql package has to offer.

If it is to low-level for your liking maybe take a look at sqlx or even gorm.

Sigh... If you're using gorm V2, you need to pass a dialector to gorm.Open as the first parameter. See the V2 example here: https://github.com/go-gorm/gorm/issues/3565

Framework - Gin ORM - Gorm

GORM is the best, it features an ORM database with syntax similar to ruby on rails.

GORM

I usually work with PostgreSQL and have used https://github.com/go-pg/pg. https://github.com/uptrace/bun is its successor.

bun and go-pg both seem to work fairly well for these kind of purposes.

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.