Library Management System
Tracking thousands of inventory items and overdue fines manually often led to significant operational errors. I implemented a barcode-based cataloging system with automated email notifications and an analytics dashboard built on Next.js and PostgreSQL. This streamlined library operations and dramatically improved inventory accuracy and member engagement.
The Challenge
Libraries often struggle with loss of inventory and manual fine tracking. I built this system to digitize the end-to-end borrowing process, making it seamless for both staff and members.
Technical Implementation
Built with Next.js and Prisma, I designed a relational schema that tracks availability in real-time. I used cron jobs for automated overdue reminders and generated dynamic reports using Chart.js on the admin dashboard.
Lessons Learned
This project taught me a lot about relational database design and how to build secure, role-based access control systems with Next-Auth.