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

366
Comments 5
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

110
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

172
Comments 14
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

149
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

83
Comments 5
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

101
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

115
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!

79
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

137
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

94
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

144
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

101
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

77
Comments 5
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

49
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

71
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

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

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

110
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

44
Comments 2
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

58
Comments 3
13 min read