AdvancedHMI Software
General Category => Application Showcase => Topic started by: Justinb94 on December 13, 2020, 11:09:44 AM
-
I have created a custom dynamic trend graph that gives the operator options to change x and y axis scale.
I used a Data Subscriber to insert 3 values (pump speed, temp and current) into a SQLite database. I then linked the chart to the SQLite database.
See the image attached for greater detail.
-
Good work.
-
Hi,
I am trying to do this however no success. Is it possible to share code?
-
Yes quite happy to share code. I would just have to go back through my projects and find it.
However, I wouldn't reckon doing this, it took hours/days of code writing and not to mention the maintenance. I have since discovered InfluxDB, Grafana and Node Red.
InfluxDB is a purpose built time series database built for trending historical data, grafan takes out all the hard work with querying databases and it provides visually appealing dashboards. Combined with node-red it takes roughly 5 mins to set this software stack up compared to hours/days of tinkering in Visual Basic code.
If you would still like the source code let me know.
-
Interesting. Have you ever tried MS Power BI?
Yes quite happy to share code. I would just have to go back through my projects and find it.
However, I wouldn't reckon doing this, it took hours/days of code writing and not to mention the maintenance. I have since discovered InfluxDB, Grafana and Node Red.
InfluxDB is a purpose built time series database built for trending historical data, grafan takes out all the hard work with querying databases and it provides visually appealing dashboards. Combined with node-red it takes roughly 5 mins to set this software stack up compared to hours/days of tinkering in Visual Basic code.
If you would still like the source code let me know.
-
I have not tried MS Power BI. I have tried to stick with an open source stack.
-
Hi Justin,
Is it possible to share your code / component ?