REST API with Go, Chi, MySQL and sqlx

• blog-code-samples

  3 2 10.0 Go

  Sample projects and code from my blog posts

  I will start by copying the content of https://github.com/kashifsoofi/blog-code-samples/tree/main/movies-api-with-go-chi-and-memory-store, placing it in a new folder movies-api-with-go-chi-and-mysql and updating module name in go.mod to match the new folder and updating in source files where its used. This will usually be the root of your git repo and will not be as elaborate as this.

• migrate

  18 12,671 7.1 Go

  Database migrations. CLI and Golang library.

  

  Before we can start using MySQL we need to create a table to store our data. I will be using excellent migrate database migrations tool, it can also be imported as a libraray.

• Onboard AI

  getonboard.dev

  sponsored

  Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.

  

• sqlx

  16 14,631 0.0 Go

  general purpose extensions to golang's database/sql

  I will be using sqlx to execute queries and map columns to struct fields and vice versa, sqlx is a library which provides a set of extensions on go's standard database/sql library.

• kelseyhightower/envconfig

  6 4,728 0.0 Go

  Golang library for managing configuration data from environment variables

  envconfig

• chi

  27 15,900 6.8 Go

  lightweight, idiomatic and composable router for building Go HTTP services

  

  chi

• docker

  106 496 0.0 Go

  Docker - the open-source application container engine (by microsoft)

  

  This is a continuation of an earlier post REST API with Go, Chi and InMemory Store. In this tutorial I will extend the service to store data in a MySQL database. I will use Docker to run MySQL and run database migrations.

Suggest a related project