Journal of Scientific Engineering Advances

Abstract

In this article, the design, development, and implementation of a Representational State Transfer Application Programming Interface (REST API) aimed at the comprehensive management of collaborative projects in or ganizational environments is described. The solution was built using the Hapi.js framework within the Node.js ecosystem, supported by a MySQL relational database, and incorporates robust authentication mechanisms, role-based authorization, and structured validation of input data. The system architecture includes five inter connected functional modules: user management with status and role control, project administration with sta tus tracking, task management with priority levels, chronological tracking records, and document attachment control linked to both projects and specific tasks.

Regarding security, the platform uses password encryption through bcrypt, stateless authentication with JSON Web Tokens (JWT), and a password recovery workflow that sends a temporary key via email. To validate all incoming data, the Joi library was used, ensuring that the information is correct before performing any da tabase operations. The UUID standard was employed for the creation of unique identifiers within the system resources.

The normalized relational database design supports five main entities (users, projects, tasks, tracking records, and documents), establishing referential integrity relationships that ensure information consistency. The ob tained results demonstrate that the proposed solution significantly reduces access and information manipula tion times compared to traditional monolithic systems, provides a uniform and predictable interface based on the HTTP protocol, and facilitates integration with different types of clients such as web, mobile, or desktop applications. Hapi.js was chosen because its route configuration is declarative and because it offers native schema validation, which helps make the code easier to maintain and scale.