DEV Community

Backend master class Series' Articles

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

Design DB schema and generate SQL code with dbdiagram.io

Reactions 245 Comments
9 min read
Install & use Docker + Postgres + TablePlus to create DB schema

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

Reactions 72 Comments 3
9 min read
How to write & run database migration in Golang

How to write & run database migration in Golang

Reactions 90 Comments 7
8 min read
Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx, sqlc

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

Reactions 81 Comments 2
16 min read
Write Go unit tests for db CRUD with random data

Write Go unit tests for db CRUD with random data

Reactions 61 Comments 4
15 min read
A clean way to implement database transaction in Golang

A clean way to implement database transaction in Golang

Reactions 99 Comments
15 min read
DB transaction lock & How to handle deadlock

DB transaction lock & How to handle deadlock

Reactions 90 Comments 3
23 min read
How to avoid deadlock in DB transaction? Queries order matter!

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

Reactions 58 Comments 2
11 min read
Deeply understand Isolation levels and Read phenomena in MySQL & PostgreSQL

Deeply understand Isolation levels and Read phenomena in MySQL & PostgreSQL

Reactions 82 Comments 6
33 min read
How to setup Github Actions for Go + Postgres to run automated tests

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

Reactions 73 Comments
15 min read
Implement RESTful HTTP API in Go using Gin

Implement RESTful HTTP API in Go using Gin

Reactions 116 Comments
19 min read
Load config from file & environment variables in Golang with Viper

Load config from file & environment variables in Golang with Viper

Reactions 56 Comments 1
8 min read
Mock DB for testing HTTP API in Go and achieve 100% coverage

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

Reactions 43 Comments 1
24 min read
Implement transfer money API with a custom params validator in Go

Implement transfer money API with a custom params validator in Go

Reactions 43 Comments
11 min read
Add users table with unique & foreign key constraints in PostgreSQL

Add users table with unique & foreign key constraints in PostgreSQL

Reactions 29 Comments
11 min read
How to handle DB errors in Golang correctly

How to handle DB errors in Golang correctly

Reactions 46 Comments 1
11 min read
How to securely store passwords?

How to securely store passwords?

Reactions 108 Comments 12
13 min read
How to write stronger unit tests with a custom go-mock matcher

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

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

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

Reactions 212 Comments 3
11 min read
How to create and verify JWT & PASETO token in Golang

How to create and verify JWT & PASETO token in Golang

Reactions 45 Comments
17 min read
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

Reactions 36 Comments
13 min read