Issue Tracker
Description
A full-stack web application designed for tracking and managing project issues. It allows users to create, view, and manage issues, with a dashboard for quick insights.
Tech Stack
Next.js
MySQL
Prisma
Radix UI
Tailwind CSS
Key Features
- Issue creation and management with full CRUD functionality
- Dashboard with issue status charts and metrics
- Filtering and sorting issues by status
- Responsive design with a modern UI/UX
- Database integration with Prisma and MySQL
Challenges & Solutions
Managing Full-stack Data Flow and State
Building a full-stack application required seamless communication between the front-end and a MySQL database. I used **Next.js** for the API routes and **Prisma** as the ORM to manage data, which simplified database queries and ensured type-safe data handling.
Creating a Secure and Scalable Data Schema
Designing the database schema for issue tracking with features like status, priority, and user assignments was a key challenge. I designed a scalable and efficient relational database model using **MySQL** and configured the schema with **Prisma** to prevent data inconsistencies.
