Back to Systems
NESTJS · TYPEORM MIGRATIONS · MYSQL DOCKER · JWT AUTH · SWAGGER·2026

Backend Rotation Project — Pet & Owner REST API

NestJSTypeORMMySQLDocker ComposebcryptSwagger
View Repository

An onboarding project I built end to end to learn the team's backend standards: separation of concerns, transactional safety and migration discipline.

01. The Problem

Rapid backend development often leads to messy code where SQL queries leak into HTTP controllers, passwords are accidentally serialized into API responses, and database schemas drift uncontrollably.

02. Architecture & Solution

Kept controllers thin with DTO validation pipes and business logic in services. Managed the schema through TypeORM migrations, hashed passwords with bcrypt and kept them out of API responses, and ran MySQL and Redis locally with Docker Compose.

Key Architectural Highlights

  • ▹Schema changes managed through versioned TypeORM migrations
  • ▹Password protection using bcrypt (10 rounds) and @Column({ select: false }) ORM exclusions
  • ▹Automated cascade deletion rules ensuring referential integrity across related entities
  • ▹Containerized MySQL 8.0 environment with persistent volumes via Docker Compose

03. Impact

Completed as my backend onboarding, and now my own reference for structuring secure, maintainable REST services.

Elgen Mar Arinasa © 2026

Let's Discuss This Project →