This project aims to build a complete backend service for an application called BankService. The service performs multiple transactions from different users with different accounts.
Design DB schema for PostgreSQL and general SQL code using dbdiagram.io. Use Docker to run this entire application. Use TablePlus to connect to PostgreSQL Server to look at the raw data.
Database migration using golang - golang-migrate. Generate CRUD (Create, Read, Update and Delete) Golang code from SQL code using Sqlc. Unit tests for the Go code for ~95% code coverage.
Perform transactions that are ACID compliant using Golang.