Today I want to tell about my little experience with MySQL (although you can use any other database here) in Go.

The way to work with the database from Go

I found a great way to work with the database from Go and can’t wait to share it.

In general, Go has several important things to do in order to make inquiries. For example, database/sql and github.com/go-sql-driver/mysql

A typical example looks like this:

And in order to map the query result into a structure, we will use github.com/jmoiron/sqlx.

SQLX is a set of extensions on top of the database/sql that allow you to make a minimal “ORM” in Go.

For example, we work with such a model

We have a simple database scheme

The connection to the database will look like this

SQLX bunch of methods

Sqlx has a bunch of methods, which start with a Must. MustExec, MustBegin. You have to use them with caution because they throw panic and your application can crash when you do not want it :)

CRUDs will look like this

That’s all. Just in case, the complete code:

Custom Software and Mobile App Development.
From Total Mess to Order in Several Steps.

Effective Refactoring of a Heavy Database Interface

Effective Refactoring of a Heavy...

Effective Refactoring of a Heavy Database Interface

This story is about pain, agony, and denial of ready-made solutions. It is also about changes that improve the code’s readability and help the...

Stripe Connect.

Integration of Stripe Connect into your Project

Integration of Stripe Connect into...

Integration of Stripe Connect into your Project

Almost every service on the Internet today deals with money. And dealing with money requires a robust Billing system. Building your own billing...

Amazon Aurora vs AWS RDS

AWS Aurora vs AWS RDS

AWS Aurora vs AWS RDS

AWS Aurora vs AWS RDS

In the realm of cloud-based database solutions, Amazon Web Services (AWS) offers an impressive array of options to cater to various business needs....