JITA

JITA Journal of Information Technology and Applications

Vol. 16 No. 1 (2026): JITA - APEIRON

Daniel Menićanin, Jelena Radanović, Dražen Marinković

Centralized Database and Distributed Communication in a Software System for High-Precision Industrial Machine Control

Review paper
DOI: https://doi.org/10.7251/JIT2601020M

Abstract

High precision in industrial processes depends not only on the mechanical and control components of the system, but also on the way data related to machine operation and operator activity are organized, stored, and processed. This paper examines the application of the relational data model and distributed communication architecture in an industrial software system intended for controlling machines in which deformation, forming, and material processing are directly conditioned by precise positioning and stable process supervision. The implemented solution includes a centralized application layer developed in the Dart programming language using the Flutter framework, a distributed microcontroller layer implemented in C++, and a centralized PostgreSQL database deployed in a Docker environment on a Proxmox server. Communication between the computer and the main control node is established via a USB-UART connection, while remote actuator and sensor modules are interconnected through a CAN bus. The system supports management of operator accounts, position presets, work sequences, worker-specific tasks, event logs, and remote access via Tailscale VPN infrastructure. The paper analyzes the database structure, relationships between tables, integrity constraints, data export and import organization, as well as security mechanisms based on PIN hashing and software license protection using asymmetric cryptography. The results show that the integration of a centralized database layer and a distributed communication architecture represents a functionally and technically justified solution for this class of industrial systems.

Keywords: PostgreSQL, RDBMS, Flutter, Dart, ESP32-S3, CAN bus, Tailscale VPN.

Paper received: 17.4.2026.
Paper accepted: 5.5.2026.

Downloaded Article PDF: 20 times

Vol. 16 No. 1 (2026): JITA - APEIRON6

Daniel Menićanin, Jelena Radanović, Dražen Marinković

Centralized Database and Distributed Communication in a Software System for High-Precision Industrial Machine Control

Review paper

DOI: https://doi.org/10.7251/JIT2601020M

Abstract

High precision in industrial processes depends not only on the mechanical and control components of the system, but also on the way data related to machine operation and operator activity are organized, stored, and processed. This paper examines the application of the relational data model and distributed communication architecture in an industrial software system intended for controlling machines in which deformation, forming, and material processing are directly conditioned by precise positioning and stable process supervision. The implemented solution includes a centralized application layer developed in the Dart programming language using the Flutter framework, a distributed microcontroller layer implemented in C++, and a centralized PostgreSQL database deployed in a Docker environment on a Proxmox server. Communication between the computer and the main control node is established via a USB-UART connection, while remote actuator and sensor modules are interconnected through a CAN bus. The system supports management of operator accounts, position presets, work sequences, worker-specific tasks, event logs, and remote access via Tailscale VPN infrastructure. The paper analyzes the database structure, relationships between tables, integrity constraints, data export and import organization, as well as security mechanisms based on PIN hashing and software license protection using asymmetric cryptography. The results show that the integration of a centralized database layer and a distributed communication architecture represents a functionally and technically justified solution for this class of industrial systems.

Keywords: PostgreSQL, RDBMS, Flutter, Dart, ESP32-S3, CAN bus, Tailscale VPN.

Paper received: 17.4.2026.
Paper accepted: 5.5.2026.

Downloaded Article PDF: 20 times

Vol. 16 No. 1 (2026): JITA - APEIRON

Daniel Menićanin, Jelena Radanović, Dražen Marinković

Centralized Database and Distributed Communication in a Software System for High-Precision Industrial Machine Control

Review paper

DOI: https://doi.org/10.7251/JIT2601020M

Abstract

High precision in industrial processes depends not only on the mechanical and control components of the system, but also on the way data related to machine operation and operator activity are organized, stored, and processed. This paper examines the application of the relational data model and distributed communication architecture in an industrial software system intended for controlling machines in which deformation, forming, and material processing are directly conditioned by precise positioning and stable process supervision. The implemented solution includes a centralized application layer developed in the Dart programming language using the Flutter framework, a distributed microcontroller layer implemented in C++, and a centralized PostgreSQL database deployed in a Docker environment on a Proxmox server. Communication between the computer and the main control node is established via a USB-UART connection, while remote actuator and sensor modules are interconnected through a CAN bus. The system supports management of operator accounts, position presets, work sequences, worker-specific tasks, event logs, and remote access via Tailscale VPN infrastructure. The paper analyzes the database structure, relationships between tables, integrity constraints, data export and import organization, as well as security mechanisms based on PIN hashing and software license protection using asymmetric cryptography. The results show that the integration of a centralized database layer and a distributed communication architecture represents a functionally and technically justified solution for this class of industrial systems.

Keywords: PostgreSQL, RDBMS, Flutter, Dart, ESP32-S3, CAN bus, Tailscale VPN.

Paper received: 17.4.2026.
Paper accepted: 5.5.2026.

Downloaded Article PDF: 20 times