Database storing

[fahrur]

hi mikahil

does the modDBexport only store data to database when the value changing?

i have problem with Frequency (Hz) values, as you know typical frequency values stable at 50 hz, and in modDBexport i see inside database, rapidscada only insert new data when the frequency changing.

as a result when the frequency value from database used in realtime chart the data trend will jump to the next changing value.

thankyou

[Mikhail]

Hi,
The module executes SQL every time when data are received from Communicator. But Communicator doesn’t send data if they are not changed. You can set the parameter Sending all device data period in Communicator to solve the issue.

[Mikhail]

How do you make charts for the data from DBMS?

[fahrur]

i use highchart spline tipe updating each second, here is highchart demo http://www.highcharts.com/demo/dynamic-update

[Mikhail]

Thanks! Do need programming to integrate it with database or it is out of the box?

[fahrur]

yes, its use javascript ajax script to load data every second

[Author]

Posts