Implementação de sincronismo para uma solução móvel de gestão pecuarista

Abstract

This work proposes an offline-first data synchronization architecture for mobile applications in rural environments, aiming to solve challenges of intermittent connectivity in family livestock management. The research is justified by the need to guarantee data integrity and availability in regions with limited internet infrastructure, where traditional solutions that depend on conti nuous connection are unfeasible. The main objective was to develop an efficient bidirectional synchronization mechanism, using SQLite for local storage and PostgreSQL as a remote database, mediated by a customized Application Programming Interface (API) for transfer and conflict resolution. The methodology included modeling the architecture, implementation of the synchronization logic and testing in simulated disconnection scenarios. The results de monstrated the effectiveness of the model in reducing latency (asynchronous synchronization), optimizing network resources and maintaining data consistency, even after long offline periods. In addition, the solution eliminated dependencies on external services, increasing the autonomy and scalability of the system. It is concluded that the offline-first approach, combined with customized synchronization, is viable for democratizing digital tools in rural contexts, ensuring resilience and adaptability to connectivity fluctuations. The study contributes with a replicable methodology for applications that require robust synchronization in disconnected environments, with the potential to assist in the modernization of family farming.