Avaliação da viabilidade do PostgREST como solução de interoperabilidade para sistemas legados: um proof of concept

Abstract

Integration between heterogeneous systems poses a recurring challenge in corporate environments, particularly when involving legacy applications developed with discontinued technologies. This work presents a proof of concept (PoC) to evaluate the technical feasibility of PostgREST as an interoperability solution between a legacy ERP system in Visual FoxPro 9 and a mobile application in React Native, both directly accessing a PostgreSQL database. The study identifies SQL query duplication issues and proposes data access centralization through SQL views automatically exposed as RESTful APIs by PostgREST. Quantitative metrics demonstrate an average reduction of 68% in VFP9 code lines and 63% in JavaScript for a sample of five representative queries. Identified limitations include external authentication requirements, need for stored procedures for complex logic, and lack of native versioning. This work contributes empirical characterization of legacy system modernization challenges via database-driven APIs.