
WebEngineering Case Study
Mosque Library Management
A full-stack web application for managing mosque libraries — Islamic book catalog browsing, member issue/return tracking, and committee role assignments with bilingual (EN/BN) support.
Relational Community Catalog & Circulation System
Role & ScopeFull-Stack Developer
Target DomainWeb · Production
Core RuntimeNext.js, TypeScript, Tailwind CSS
Operational & Architectural Invariants:
Bilingual English/Bengali UI parityRelational foreign-key loan integrityRole-based circulation workflows
The Problem
Community mosque libraries frequently encounter lost books, untracked loans, and manual paper records, making it difficult for patrons to discover available literature.
Technical Approach
Developed a modern web portal using Next.js, TypeScript, and Prisma ORM backed by PostgreSQL, with responsive layouts in Tailwind CSS and bilingual language support.
Key Highlights & Architecture
- Comprehensive Islamic book catalog with search, categorization, and availability tracking
- Member borrowing lifecycle with due dates, loan renewals, and overdue alerts
- Bilingual English and Bengali localization for seamless community accessibility
Engineering Challenges
- Managing book loan states (Issued, Overdue, Returned, Lost) and renewal limits.
- Providing quick search across both Bengali and English book titles and author names.
Key Engineering Decisions
- Relational Schema: Enforced strict foreign keys connecting books, copies, members, and loan transactions to maintain audit integrity.
- Bilingual UI Localization: Built lightweight dictionary-based localization to cater to both local and international patrons.
Result & Outcome
Delivered an accessible web catalog and lending management system ready for community library operations.
Technologies & Tools
Next.jsTypeScriptTailwind CSSFull-StackPrismaPostgreSQL