This article will teach you how to build a CRUD RESTful API in Golang that runs on a Gonic Gonic framework and uses a PostgreSQL database. Also, you will learn how to generate the CRUD Functions and Structs with SQLC. We will run the database migration with the Golang migrate library.
- Setup and Run PostgreSQL with Docker and Docker-compose
- Setup and Run Database Migration in Golang
- Generate the CRUD Functions and Structs with SQLC
- Load the Environment Variables with Viper
- Create Custom Structs to Validate the Request Body
- Create the Gin Gonic Route Controllers
- Create the Gin Gonic Routes
- Add the Routes to the Middleware Pipeline
- Test the SQLC + Golang CRUD API with Postman
Read the entire article here: https://codevoweb.com/golang-crud-restful-api-with-sqlc-and-postgresql
Articles in this series:
How to Setup SQLC CRUD API with Golang and Gin Gonic