Scholars Library App
// Cross-Platform Library Operations System
A cross-platform library management system engineered with Flutter and Supabase PostgreSQL. Supports multi-role navigation (Admin, Librarian, Student), interactive visual seat map with real-time occupancy status, and an offline-first QR scanning module for rapid student attendance verification.
Real-time Seat Map
Cross-Platform
Instant QR Scan
[ ARCHITECTURAL INSPECTOR ]
System Design & Code
Architectural Overview & Pipeline
Scholars Library App is a cross-platform mobile and desktop facility operations suite built with Flutter, Dart, and Supabase. The system manages dynamic seat reservation maps, catalog checkouts, and offline-first QR student attendance, relying on PostgreSQL exclusion constraints to prevent double-booking collisions.
Primary Stack:
Engineering Challenges & Solutions
Implemented database-level GIST range exclusion constraints that reject second-order mutations with standard SQL 23P01 exclusion violations.
Architected an offline-first SQLite log on the Flutter client that digitally signs scan timestamps locally and flushes batches sequentially once connectivity resumes.