Posts: 1
Joined: Wed Jan 08, 2020 1:39 pm

Get data from mySQL db to Windows Form Application

Wed Jan 08, 2020 2:29 pm

Hello All;

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.

Posts: 6
Joined: Wed Jan 22, 2020 6:04 pm

Re: Get data from mySQL db to Windows Form Application

Tue Feb 04, 2020 5:18 pm

Have you considered an alternative dashboard application instead of Node-Red? I have recently used MQTT-Hyperdash, but it does not run on WINDOWS: (linux only).
Here is the link: https://github.com/kollokollo/MQTT-Hyperdash

For an Android Smartphone I have used the app "MQTT-Dash" from the play store. It is nice and easy to use, but I believe, Charts are not possible.

And if you just want to visualize data in a chart, plot or table, why considerung mqtt at all?
gnuplot on a Raspbery Pi would do. Ok, I see, there is no interface to SQL. Gnuplot can only handle files.
So a quirqy solution would be: Publish data to a MQTT broker, and setup a logger-app which writes all changes of the topic to a file. The file finally can be plotted with gnuplot, this way you get a chart/plot. You can even output .png images which can be published back to the mqtt-Broker....

Return to “Other programming languages”