go-pg VS sqlx

For database communication we will use go-pg module. You can install it by running go get github.com/go-pg/pg/v10. This will install version 10 of go-pg module, which is latest version at the time of writing this guide. Now create new directory internal/database/ and file database.go inside of it.

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.

This one is mostly excellent: https://github.com/go-pg/pg

Using the correct driver to connect to the database + https://github.com/jmoiron/sqlx. You will always receive a JSON array on the output with which it is very convenient to work.

For convenience, it is better to use https://github.com/lib/pq in conjunction with https://github.com/jmoiron/sqlx, you will have all the data in json

There are ORMs available for Golang, but my experience has been better with packages like sqlx [1] or dat [2]. We've since been using SQLX for pretty much all DBMS related work, and regret nothing. In my experience SQLX gave us the right balance between abstraction and control.

[1] http://jmoiron.github.io/sqlx/

[2] https://github.com/mgutz/dat

Line 44 in: https://github.com/jmoiron/sqlx/blob/a1d5e64734233358bc4e0a54beddc18509071a95/reflectx/reflect_test.go

Say we want to insert the following data using INSERT query to a mysql database - say SampleDatabase (using sqlx - https://github.com/jmoiron/sqlx) type Sample struct { A int64 B string Data interface{} } Data can be type C struct{} or type D struct{} or nil type C struct{} and type D struct{} have fields defined within them like type C struct{ E int64 F string }

sqlx which make working with database painless. It's really vital for my job since as an ordinary developer my jobs often revolved on creating CRUD apps. It also uses SQL query, so I don't have to learn any ORMs.

Maybe most efficient guide: http://jmoiron.github.io/sqlx/

https://github.com/jmoiron/sqlx : Great extension of the standard database/sql package, but 100% compatible with it