Web Application for Inventory Management at the Eastern Pacific Fishing School

Abstract

Context: This article addresses the design, development, and implementation of a custom web solution for the Eastern Pacific Fishing School (EPESPO) to modernize and automate its asset control. The institutional problem lied in a high dependence on manual records and office spreadsheets that compromised data integrity, caused duplications, and removed the traceability of the life cycle of assets. Method: Based on an agile development methodology (Scrum), a decoupled Client-Server architecture was built using React JS in the frontend, Laravel as the backend framework for business logic processing, and PostgreSQL as the relational database management system. Data collection was carried out through a population census that included structured interviews with administrative staff. Results: The implemented system successfully centralized asset management, digitized transactional flows of assignment, return, and disposal of assets, and automated the generation of legal forms in PDF format. Technical software validation through stress and referential integrity testing guaranteed complex query response times under two seconds and 100% stability under concurrent transactions. Conclusions: The results demonstrate the definitive eradication of data inconsistencies and a substantial optimization in institutional auditing and fiscal oversight times.