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?

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.

[Justinb94]

I have not tried MS Power BI.  I have tried to stick with an open source stack.

[ibah]

Hi Justin,

Is it possible to share your code / component ?