Developing a Robust Shiny Application Integrated with SQL Databases for Aquaculture

Abstract

This work presents the development of an application for managing collective feed
purchases in aquaculture, aiming to reduce costs and optimize logistics. This study aims to val-
idate the robustness of applications developed using the Shiny framework of the R programming
language by integrating a Database Management System (DBMS) in the backend. This aims to
demystify the predominant perception that Shiny is exclusively a prototyping tool, demonstrating
its viability for robust production applications. The adopted methodology encompasses three stages
of software development: Backend, Intermediate Infrastructure, and Frontend. In the Backend
stage, database modeling was carried out, which included conceptual, logical, and physical mod-
eling, ensuring the system’s efficiency and security. The choice of PostgreSQL as DBMS was
based on the need for a robust and secure system. The Intermediate Infrastructure was developed
using the R language with the Golem framework, facilitating the application’s development and
deployment. Its folder and metadata structures promote efficient project organization. The Fron-
tend was built with the Shiny framework, standing out for its modularity and code organization.
The developed modules include the interface and system logic for each specific functionality, such
as supplier registration and stock management. Overall, the work presents a systematic and or-
ganized approach to application development, encompassing database modeling to user interface
implementation, aiming to meet the needs of collective feed purchase management in aquaculture.