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

Type

Hackathon / Bounty