General Category > Application Showcase
Custom Trending with SQLite
Justinb94:
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.
MajorFault:
Good work.
Alpaslan:
Hi,
I am trying to do this however no success. Is it possible to share code?
Justinb94:
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.
Noe:
Interesting. Have you ever tried MS Power BI?
--- Quote from: Justinb94 on May 12, 2021, 09:20:46 PM ---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.
--- End quote ---
Navigation
[0] Message Index
[#] Next page
Go to full version