HTPA32x32 infrared sensor array values to a database

Other Hardware Sensors
1

Hi all, currently I am working on a Project that monitors the the motor contact using Infrared Thermography using HTPA32x32d Infrared Sensor to obtain the matrix values of the thermal image.

My next task is to send the matrix values to a php MySQL Database which will be used to either display or for trend analysis for further analytical purposes to detect for any abnormalizes.

I was wondering:

  • How do I send the matrix values to the MySQL database using an ESP32 Wroom Board ?
  • How do I do the php query to record the the matrix values into the MySQL Database ?
2

Does it have to be MySQL? There are other databases like influxdb that are designed for time series data. It uses a SQL like language as well.

A IoT sensor data system often used looks as follows.

  • MQTT protocol to send small amounts of sensor data with little overhead
  • Raspberry Pi as MQTT broker using mosquitto

  • PubSubClient - MQTT library for ESP32 and other Arduino compatible boards

  • Node-RED - flow-based development tool for visual programming, comes with Raspberry PiOS, supports MQTT, database access, graphical display of data can be extended with open source nodes and JavaScript

https://nodered.org/

You can find lots of web pages and Youtube videos about all of these. It is easy to extend for many sensors and you can do all kinds of stuff with the data.

3

Klaus_K:
Does it have to be MySQL? There are other databases like influxdb that are designed for time series data.

Yeah, it had to be MySQL unfortunately because of most of my project is built around MySQL

4

noonenew11:
Yeah, it had to be MySQL unfortunately because of most of my project is built around MySQL

You could still use the setup mentioned above. I did a quick search in my Node-RED and found multiple nodes for MySQL. e.g.

I do not know the status e.g. how often they are updated, but this one seems active with last update one month ago.

5

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.