github.com/Nitrajsinh-Solanki/library-inventory-system
01 / 11
๐ $90 ยท 3rd Place
Library & Book Store Inventory System
Built for the StackUp Hackathon, this system covers the complete lifecycle of a library โ from adding books and managing users to borrowing, tracking overdue returns, and calculating fines automatically. Admins can promote users to Librarian role, configure fare settings, and monitor all transactions from a central dashboard. Book cover images are stored on Supabase Storage, and Google Gemini AI auto-generates book descriptions on demand.
Engineering Case Study
- Challenge
- A library needs one place to manage its catalogue, members, borrowing, overdue returns and fines, while restricting sensitive actions to the right roles.
- Approach
- Combine a Next.js and TypeScript interface with MongoDB/Mongoose data models, NextAuth and JWT sessions, email OTP verification, Supabase Storage for book covers, and Gemini for optional AI-written descriptions.
- Contribution
- Implemented Admin, Librarian and User workflows; protected dashboard routes; book borrowing and return logic; automatic fine calculations; configurable borrowing rules; email verification; cover uploads; and AI-assisted descriptions.
- Outcome
- Delivered a demonstrable end-to-end library workflow and earned 3rd place ($90) in the StackUp Hackathon. Separate demos show the Admin, Librarian and User experiences.
Key Features
- Three role system โ Admin, Librarian, User with route-level protection
- AI-generated book descriptions via Google Gemini
- Borrow & return system with automatic fine calculation
- Email OTP verification before account activation
- Book cover image uploads to Supabase Storage
- Admin dashboard with analytics โ user count, active borrows, overdue list
- Configurable fare settings โ borrowing fees, late penalties, borrowing limits
- JWT + NextAuth session management
Tech Stack
Next.jsTypeScriptMongoDBMongooseSupabase StorageGoogle Gemini AINextAuthJWTNodemailerTailwind CSS
Award
Prize
$90
Placement
3rd Place
Event
StackUp Hackathon