Criação de Blocos para conexão com banco de dados MySQL no Block-Based Integrated Platform for Embedded Systems (BIPES)

Abstract

The no-code development trend, also known as no-code or low-code, has gained popularity for its ability to speed up the development process and allow people with no programming experience to create solutions in a simplified way. A solution that fits this trend is the Block based Integrated Platform for Embedded Systems (BIPES), a platform for developing embedded systems based on blocks, designed to make it easier to create electronic projects without the need for advanced knowledge in programming. With BIPES, users can create programs to control electronic devices by combining pre-programmed graphic blocks that perform specific functions, without the need to write code. The platform is compatible with several popular microcontrollers, such as ESP8266 and ESP32, and offers a user-friendly graphical interface to facilitate the creation of programs. To meet the needs of users already familiar with databases, blocks were developed for sending data from ESP32 to a MySQL database. These blocks were created to help collect analog and digital data read by the ESP32 and send this data to a MySQL database through a PHP code that communicates and processes the data. With the use of these blocks, it is possible to collect data in real time from the ESP32 and store them in a database, allowing this data to be analyzed later and used for different purposes. To validate the effectiveness of the blocks for sending data developed in BIPES, a DHT11 sensor connected to an ESP32 board was used. The sensor was used to collect temperature and humidity data from the environment, and the blocks were configured to send this data to a MySQL database. Throughout the validation process, it was possible to confirm the functionality of the blocks and the correct communication between the ESP32 and the database, allowing the collection and storage of data in real time. Block validation was an important step to ensure the reliability and efficiency of the system for sending data to MySQL databases developed at BIPES.