- Notifications
You must be signed in to change notification settings - Fork3
This article will teach you how to set up a SQLC API project with Golang, standard Database/SQL package, Gin Gonic, PostgreSQL, Golang-migrate, and Docker-compose. You will also learn how to generate Golang database CRUD functions and Structs with the SQLC compiler. The SQLC Golang API will use a PostgreSQL database and run on the Gin Gonic HTTP…
wpcodevo/golang-postgresql-api
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
This article will teach you how to use the RS256 algorithm to implement JSON Web Token (JWT) Authentication and Authorization with Golang, Gin Gonic, SQLC, PostgreSQL, and Docker-compose. Also, you will learn how to use asymmetric encryption (private and public keys) to generate access and refresh JWTs in Golang.
- Golang & SQLC JWT Authentication Overview
- Setup Environment Variables with Viper
- Define the Database User models with Structs
- Define Helper Functions to hash and verify Passwords
- Define Utility functions to Sign and Verify JWT Tokens
- Create the Authentication Route Handlers
- Create an Authentication middleware
- Setup routing with Gin
- Configure the Main Server File
Read the entire article here:https://codevoweb.com/golang-postgresql-api-access-and-refresh-tokens
Articles in this series:
How to Setup SQLC CRUD API with Golang and Gin Gonic
About
This article will teach you how to set up a SQLC API project with Golang, standard Database/SQL package, Gin Gonic, PostgreSQL, Golang-migrate, and Docker-compose. You will also learn how to generate Golang database CRUD functions and Structs with the SQLC compiler. The SQLC Golang API will use a PostgreSQL database and run on the Gin Gonic HTTP…
Topics
Resources
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Releases
Packages0
Uh oh!
There was an error while loading.Please reload this page.