Student Management System
A full stack student management system with a 70+ table PostgreSQL schema, optimized queries, and containerized cloud deployment.
- Next.js
- PostgreSQL
- Prisma
- Kysely
- Docker
Overview
A comprehensive student management system delivered as a freelance project, covering frontend functionality, backend services, database architecture, and deployment.
What I built
- Implemented end-to-end features with Next.js, REST APIs, and PostgreSQL.
- Designed and optimized a 70+ table schema with Prisma ORM; tuned read-heavy queries with Kysely across 4+ joins.
- Containerized the stack with Docker and applied OWASP hardening.
Highlights
- 70+ table relational schema designed for data integrity and performance.
- Query optimization for complex multi-join reads.