Database Systems · Web Application Architecture
Backend & Database Systems
Auth, SQL, and microservices done by hand.
- Year
- 2025
- Role
- Engineer
- Status
- Shipped
- Type
- Database Systems
A set of from-scratch backend builds: JWT/HMAC auth APIs, a relational recipe app, and a Dockerized microservices reservation system.
The problem
Coursework that I treated as backend practice: write the auth, design the schema, split the services, containerize it.
Approach
- Built token-authenticated REST APIs in Flask with JWT/HMAC, hand-written parameterized SQL, and proper migrations.
- Designed normalized relational schemas and split a reservation system into users / availability / reservations / payments microservices, each independently Dockerized with Docker Compose.
- Deployed Flask services to Google Cloud with a GitLab CI pipeline.
Impact
- Covers the backend fundamentals interviewers actually probe: auth correctness, schema design, service boundaries, containers.
Stack
Backend
PythonFlaskFastAPI
Data
PostgreSQLSQLiteParameterized SQL
Infra
Docker ComposeCaddyGitLab CIGoogle Cloud