DEV Community

Backend master class Series' Articles

Back to TECH SCHOOL's Series
Design DB schema and generate SQL code with dbdiagram.io
Cover image for Design DB schema and generate SQL code with dbdiagram.io

Design DB schema and generate SQL code with dbdiagram.io

356
Comments 4
9 min read
Install & use Docker + Postgres + TablePlus to create DB schema
Cover image for Install & use Docker + Postgres + TablePlus to create DB schema

Install & use Docker + Postgres + TablePlus to create DB schema

105
Comments 5
9 min read
How to write & run database migration in Golang
Cover image for How to write & run database migration in Golang

How to write & run database migration in Golang

165
Comments 11
8 min read
Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx, sqlc
Cover image for Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx, sqlc

Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx, sqlc

140
Comments 2
16 min read
Write Go unit tests for db CRUD with random data
Cover image for Write Go unit tests for db CRUD with random data

Write Go unit tests for db CRUD with random data

82
Comments 4
15 min read
A clean way to implement database transaction in Golang
Cover image for A clean way to implement database transaction in Golang

A clean way to implement database transaction in Golang

166
Comments 3
15 min read
DB transaction lock & How to handle deadlock
Cover image for DB transaction lock & How to handle deadlock

DB transaction lock & How to handle deadlock

113
Comments 4
23 min read
How to avoid deadlock in DB transaction? Queries order matter!
Cover image for How to avoid deadlock in DB transaction? Queries order matter!

How to avoid deadlock in DB transaction? Queries order matter!

76
Comments 4
11 min read
Deeply understand Isolation levels and Read phenomena in MySQL & PostgreSQL
Cover image for Deeply understand Isolation levels and Read phenomena in MySQL & PostgreSQL

Deeply understand Isolation levels and Read phenomena in MySQL & PostgreSQL

132
Comments 9
33 min read
How to setup Github Actions for Go + Postgres to run automated tests
Cover image for How to setup Github Actions for Go + Postgres to run automated tests

How to setup Github Actions for Go + Postgres to run automated tests

89
Comments
15 min read
Implement RESTful HTTP API in Go using Gin
Cover image for Implement RESTful HTTP API in Go using Gin

Implement RESTful HTTP API in Go using Gin

141
Comments
19 min read
Load config from file & environment variables in Golang with Viper
Cover image for Load config from file & environment variables in Golang with Viper

Load config from file & environment variables in Golang with Viper

100
Comments 3
8 min read
Mock DB for testing HTTP API in Go and achieve 100% coverage
Cover image for Mock DB for testing HTTP API in Go and achieve 100% coverage

Mock DB for testing HTTP API in Go and achieve 100% coverage

69
Comments 2
24 min read
Implement transfer money API with a custom params validator in Go
Cover image for Implement transfer money API with a custom params validator in Go

Implement transfer money API with a custom params validator in Go

48
Comments
11 min read
Add users table with unique & foreign key constraints in PostgreSQL
Cover image for Add users table with unique & foreign key constraints in PostgreSQL

Add users table with unique & foreign key constraints in PostgreSQL

38
Comments
11 min read
How to handle DB errors in Golang correctly
Cover image for How to handle DB errors in Golang correctly

How to handle DB errors in Golang correctly

69
Comments 2
11 min read
How to securely store passwords?
Cover image for How to securely store passwords?

How to securely store passwords?

122
Comments 13
13 min read
How to write stronger unit tests with a custom go-mock matcher
Cover image for How to write stronger unit tests with a custom go-mock matcher

How to write stronger unit tests with a custom go-mock matcher

44
Comments
13 min read
Why PASETO is better than JWT for token-based authentication?

Why PASETO is better than JWT for token-based authentication?

94
Comments 6
11 min read
How to create and verify JWT & PASETO token in Golang
Cover image for How to create and verify JWT & PASETO token in Golang

How to create and verify JWT & PASETO token in Golang

86
Comments
17 min read
Implement login user API that returns PASETO or JWT access token in Go
Cover image for Implement login user API that returns PASETO or JWT access token in Go

Implement login user API that returns PASETO or JWT access token in Go

57
Comments 3
13 min read