Ticketrax
An issue-tracking system for teams to log, track, and resolve tickets, built on Next.js with a relational Postgres schema in Prisma.
Fullstack Development
2 months
Introduction
An issue-tracking system for teams to log, track, and resolve tickets, built on Next.js with a relational Postgres schema in Prisma.
Work Done
Full System Build
Challenges
Building a system with complex user roles (requesters vs. support agents), ensuring real-time updates for ticket status, and providing a clean, easy-to-use interface for reporting and managing incidents.
Solutions
I engineered a robust, single system that handles multiple ticket types (incidents, requests, support) for various departments. The dashboard provides clear metrics and workflows for efficient resolution.
Results
I successfully launched a specialized ticket management system that simplifies internal support workflows, making collaboration faster and making it easier to track and resolve team issues.
Details
A tracker built on solid relations
Ticketrax lets teams log, track, and resolve support tickets. The interesting part is the state: ticket statuses (Open, In Progress, Closed) and user roles, which take real care to model.
Data integrity first
A ticketing system is all relations: a user has many tickets, a ticket belongs to one project. I built the relational schema in PostgreSQL (Neon) with Prisma and defined explicit cascade rules, so when a user deletes their account, the system knows exactly what to do with their leftover tickets instead of leaving orphaned rows behind.
Performance
It's hosted on Vercel and uses Next.js caching, so the static parts of the dashboard are served from the edge and load fast wherever the user is.
Video Showcase
Tope Akintola
November 28, 2025
Fullstack Development
