Hi everyone,


How can I get local data periodically from an external database connection?
For example, every one hour I must update a chart with a new point value.
Is it possible?

Thanks!

Solution

Is your question to update a local Entity (i.e. add a new row) every hour from another (external) table, or to update a graph on a (otherwise static) web screen every hour?

In the first case you could code the copy logic inside a timer, but you must ask yourself why not fetch the data to be displayed directly from the original (external) table.

For the second case, you could use javascript's setTimeout() and reload() functions

https://www.w3schools.com/js/js_timing.asp

https://www.w3schools.com/jsref/met_loc_reload.asp


Miguel

Solution