Currently i have project that involved streaming data from IoT and IIoT. One of the requirement is plotting fast and can easily scroll and jump to specified time index.
We are using timescale/pgsql to store time series, but we want to use data reflection to cache the data for optimized for querying and displaying to console.
Can we do data reflection in realtime? I mean when the data is arrived the reflection is directly updated.
Or do you have any other ideas around this?