|
1 | | -#API withGolang, PostgreSQL, SQLC, Docker & Gin Gonic |
| 1 | +#Golang CRUD RESTful API with SQLC and PostgreSQL |
2 | 2 |
|
3 | | -###1. API with Golang, PostgreSQL, SQLC & Gin Gonic: Project Setup |
4 | | -[API with Golang, PostgreSQL, SQLC & Gin Gonic: Project Setup](https://codevoweb.com/api-golang-postgresql-sqlc-gin-gonic-project-setup) |
| 3 | + |
5 | 4 |
|
6 | | -###2. Build Golang & PostgreSQL API: JWT Access and Refresh Tokens |
7 | | -[Build Golang & PostgreSQL API: JWT Access and Refresh Tokens](https://codevoweb.com/golang-postgresql-api-access-and-refresh-tokens) |
| 5 | +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. |
| 6 | + |
| 7 | +##Topics Covered |
| 8 | + |
| 9 | +- Setup and Run PostgreSQL with Docker and Docker-compose |
| 10 | +- Setup and Run Database Migration in Golang |
| 11 | +- Generate the CRUD Functions and Structs with SQLC |
| 12 | +- Load the Environment Variables with Viper |
| 13 | +- Create Custom Structs to Validate the Request Body |
| 14 | +- Create the Gin Gonic Route Controllers |
| 15 | +- Create the Gin Gonic Routes |
| 16 | +- Add the Routes to the Middleware Pipeline |
| 17 | +- Test the SQLC + Golang CRUD API with Postman |
| 18 | + |
| 19 | +Read the entire article here:[https://codevoweb.com/golang-crud-restful-api-with-sqlc-and-postgresql](https://codevoweb.com/golang-crud-restful-api-with-sqlc-and-postgresql) |
| 20 | + |
| 21 | +Articles in this series: |
| 22 | + |
| 23 | +###1. How to Setup SQLC CRUD API with Golang and Gin Gonic |
| 24 | +[How to Setup SQLC CRUD API with Golang and Gin Gonic](https://codevoweb.com/api-golang-postgresql-sqlc-gin-gonic-project-setup) |
| 25 | + |
| 26 | +###2. Golang, SQLC, and PostgreSQL: JWT Access & Refresh Tokens |
| 27 | +[Golang, SQLC, and PostgreSQL: JWT Access & Refresh Tokens](https://codevoweb.com/golang-postgresql-api-access-and-refresh-tokens) |
8 | 28 |
|
9 | 29 | ###3. Golang CRUD RESTful API with SQLC and PostgreSQL |
10 | | -[Golang CRUD RESTful API with SQLC and PostgreSQL](https://codevoweb.com/golang-crud-restful-api-with-sqlc-and-postgresql) |
| 30 | +[Golang CRUD RESTful API with SQLC and PostgreSQL](https://codevoweb.com/golang-crud-restful-api-with-sqlc-and-postgresql) |