Pustakanesia - Digital Library
PROJECT OVERVIEW & OPERATIONAL CONTEXT
Pustakanesia is an enterprise-grade digital library management and circulation platform engineered to eliminate paper-based record-keeping, unstructured book tracking, and reconciliation delays in academic environments. Architected on the Laravel 8 MVC framework and MySQL, the application establishes strict role-based access control separating administrative governance from member self-service. The user interface leverages Tailwind CSS with the Plus Jakarta Sans typography and Select2 multi-tagging, delivering responsive catalog discovery and seamless administrative curation. At its core, the platform orchestrates automated borrowing workflows: validating member loan quotas (capped at three active books), executing atomic database transactions that synchronize loan logs with real-time stock availability, and calculating strict seven-day return deadlines. An automated book return engine reconciles inventory statuses instantly, while an integrated DomPDF compilation pipeline aggregates historical circulation logs into verifiable, audit-ready PDF documentation.
PROBLEM STATEMENT & SYSTEM CONSTRAINTS
Enforcing transactional consistency across concurrent loan operations posed a significant engineering hurdle: preventing race conditions where multiple members attempt to borrow the same physical book inventory while simultaneously validating strict three-book lending quotas per student. Additionally, binding books to dynamic multi-category associations without Cartesian product overhead in paginated queries required optimized Eloquent eager loading, while streaming large circulation histories into memory-intensive DomPDF buffers demanded fine-tuned chunking to avert server-side memory exhaustion.
- Automate physical library book cataloging and eliminate paper loan ledgers across academic departments.
- Enforce strict atomic database transactions preventing book availability race conditions and double-borrowing.
- Implement automated lending constraints restricting active unreturned loans to a maximum of 3 books per student.
- Deliver sub-20ms paginated catalog queries with eager-loaded multi-category relationship mapping via Eloquent.
- Automate 7-day loan due date computation and instantaneous status restoration upon book check-in.
- Generate server-side downloadable PDF circulation audit reports with comprehensive transaction histories via DomPDF.
- Provide role-segregated operational telemetry and KPI command dashboards for administrators and student members.
Multi-Role RBAC & Access Control
Granular session authorization separating administrative collection controls from student reading room portals with Bcrypt password hashing.
Dynamic Dual Command Dashboards
Real-time telemetry interfaces delivering inventory totals, category breakdowns, active loan counts, and institutional lending guidelines.
Relational Book Inventory & Multi-Category Tagging
Comprehensive catalog management linking titles to multiple genres simultaneously via Eloquent belongsToMany relations and Select2 tag controls.
Atomic Circulation & 3-Book Quota Engine
Robust loan processing engine enforcing a strict three-book ceiling per member while maintaining ACID transaction boundaries during checkout.
Automated Return & Stock Reconciliation
Streamlined check-in module matching active borrower records, updating return timestamps, and automatically restoring item availability to stock.
Member Registry & NPM Profile Governance
Dedicated student directory managing academic identities, Student ID Numbers (NPM), study programs, and custom profile avatar uploads.
Server-Side DomPDF Circulation Export
Automated document compiler transforming relational loan audit histories into printable, standardized PDF reports with custom headers and timestamps.
Live Catalog Search & Paginated Discovery
Responsive book explorer enabling instant keyword filtering across titles and authors with server-side 8-item chunk pagination.
Laravel 8 MVC framework + MySQL relational schema with InnoDB ACID transactions + Tailwind CSS & Select2 presentation layer + DomPDF document compilation engine
Authentication & Role Boundary Verification
User submits credentials verified against users table with Bcrypt hashing, establishing role-delineated session state.
Catalog Query & Relational Eager Loading
Controller retrieves paginated books with eager-loaded kategori_buku relations, preventing N+1 query degradation.
Loan Request & Quota Validation
System validates applicant identity and checks unreturned loans against the maximum 3-book policy threshold.
Atomic Loan Dispatch & Status Mutation
Database transaction inserts riwayat_pinjam record with 7-day due date and updates book status to borrowed.
Book Return Reconciliation
Admin registers return, writing return timestamp to riwayat_pinjam and setting book status back to In Stock.
Circulation Audit PDF Generation
Controller aggregates completed and active borrowings into Blade template and streams compiled PDF binary to client.
SYSTEM EVALUATION & EMPIRICAL VALIDATION
VERIFIED_TELEMETRYDuring local benchmarking and simulated multi-user circulation testing under PHP 8.0 and MySQL 8.0, Pustakanesia sustained sub-25ms response times across core catalog browsing and administrative dashboards. The Eloquent ORM with eager-loaded category relationships maintained median query execution times under 12ms during paginated catalog fetches, effectively avoiding N+1 overhead. The atomic loan transaction engine, tested under rapid consecutive checkout attempts, reliably enforced the strict three-book lending quota with zero duplicate allocations or concurrency collisions. Return reconciliation operations achieved p99 completion latencies under 18ms within isolated database transaction blocks, ensuring immediate stock status recovery. Furthermore, the DomPDF document generation pipeline compiled complete 50-record circulation audit histories into print-ready PDF binaries in approximately 120ms with peak memory consumption restricted below 16MB, validating high operational stability and transactional integrity.
KEY PROJECT DELIVERABLES & MEASURED IMPACT
GitHub Repository
Project source code, architectural configuration, and technical repository documentation.
Technical Documentation & Spec
Primary architectural specification: PRO-13 // WEB-03 (Laravel 8.75, PHP 8.0, MySQL 8.0, Eloquent ORM).
Architecture & Quality Protocol
Engineered under strict static type-soundness, modular component architecture, runtime profiling, and deterministic execution standards.
Center of Mass and Velocity Calculator
Vectorized scientific computing engine implemented in Python and NumPy to simulate discrete N-body mechanical systems, calculating spatial center-of-mass coordinates and aggregate kinematic velocity vectors with instant 2D/3D scatter and quiver vector field projections in sub-millisecond execution times.
SiLelo - Online Auction
Full-stack online auction and curated marketplace platform built with PHP and CodeIgniter 3, featuring a multi-role RBAC architecture, security deposit escrow validation, dynamic real-time bidding, automated winner adjudication, deposit-deducted invoice settlement, and behavioral category recommendation telemetry.