Skip to content

DEV Community

Backend master class Series' Articles

Back to TECH SCHOOL's Series

Cover image for Design DB schema and generate SQL code with dbdiagram.io

Jun 8 '20

Design DB schema and generate SQL code with dbdiagram.io

#database #tutorial #webdev #beginners

9 min read

Cover image for Install & use Docker + Postgres + TablePlus to create DB schema

Jun 13 '20

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

#database #docker #beginners #tutorial

9 min read

Cover image for How to write & run database migration in Golang

Jul 10 '20

How to write & run database migration in Golang

#go #database #tutorial #beginners

8 min read

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

Jul 13 '20

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

#go #database #tutorial #beginners

16 min read

Cover image for Write Go unit tests for db CRUD with random data

Aug 12 '20

Write Go unit tests for db CRUD with random data

#go #database #testing #tutorial

15 min read

Cover image for A clean way to implement database transaction in Golang

Aug 16 '20

A clean way to implement database transaction in Golang

#go #database #tutorial #beginners

15 min read

Cover image for DB transaction lock & How to handle deadlock

Aug 27 '20

DB transaction lock & How to handle deadlock

#go #database #tutorial #webdev

23 min read

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

Sep 2 '20

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

#go #database #tutorial #webdev

11 min read

Cover image for Deeply understand Isolation levels and Read phenomena in MySQL & PostgreSQL

Sep 15 '20

Deeply understand Isolation levels and Read phenomena in MySQL & PostgreSQL

#database #tutorial #webdev #beginners

33 min read

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

Sep 25 '20

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

#go #github #devops #tutorial

15 min read

Cover image for Implement RESTful HTTP API in Go using Gin

Oct 26 '20

Implement RESTful HTTP API in Go using Gin

#go #tutorial #beginners #webdev

19 min read

Cover image for Load config from file & environment variables in Golang with Viper

Nov 2 '20

Load config from file & environment variables in Golang with Viper

#go #tutorial #beginners #webdev

8 min read

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

Nov 14 '20

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

#go #testing #tutorial #webdev

24 min read

Cover image for Implement transfer money API with a custom params validator in Go

Dec 7 '20

Implement transfer money API with a custom params validator in Go

#go #tutorial #webdev #beginners

11 min read

Cover image for Add users table with unique & foreign key constraints in PostgreSQL

Dec 27 '20

Add users table with unique & foreign key constraints in PostgreSQL

#database #tutorial #webdev #beginners

11 min read

Cover image for How to handle DB errors in Golang correctly

Jan 1 '21

How to handle DB errors in Golang correctly

#go #database #tutorial #webdev

11 min read

Cover image for How to securely store passwords?

Jan 16 '21

How to securely store passwords?

#go #tutorial #webdev #security

13 min read

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

Feb 21 '21

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

#go #tutorial #testing #beginners

13 min read

Feb 21 '21

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

#security #webdev #beginners

11 min read

Cover image for How to create and verify JWT & PASETO token in Golang

Apr 5 '21

How to create and verify JWT & PASETO token in Golang

#go #tutorial #webdev #beginners

17 min read

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

Apr 24 '21

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

#go #tutorial #webdev #beginners

13 min read