I developed an IoT project with using Mosquitto Broker, Node-Red, and phpmyAdmin mySQL database.
Multiple NodeMCU sends data to MQTT broker (mosquitto broker installed on RaspberryPi3). Then data stored on mySQL database via using Node-Red. In order to connect nodeMCU clients to RPi MQTT Broker universally, port forwarding is used.
I want to visualize mySQL data, NodeRed dashboard is not enough.
I have an Windows Form Application that had been prepared before with C# via visual studio. Can I get data from MySQL database with queries for Windows Form Application and how?.
If it is not applicable how can I visualize my data with graphs and tables?
Any help will be appreciated.
Thanks in advance.