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 272 Comments
9 min read
Install & use Docker + Postgres + TablePlus to create DB schema

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

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

How to write & run database migration in Golang

Reactions 114 Comments 9
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 97 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 68 Comments 4
15 min read
A clean way to implement database transaction in Golang

A clean way to implement database transaction in Golang

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

DB transaction lock & How to handle deadlock

Reactions 94 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 59 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 92 Comments 7
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 78 Comments
15 min read
Implement RESTful HTTP API in Go using Gin

Implement RESTful HTTP API in Go using Gin

Reactions 121 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 65 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 51 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 42 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 32 Comments
11 min read
How to handle DB errors in Golang correctly

How to handle DB errors in Golang correctly

Reactions 52 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 28 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 222 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 51 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 38 Comments 1
13 min read