Database connection type
Grafieks can establish two types of connections to your database. They are:
- Live
- Real-time
The terms "live data connection" and "real-time" are related concepts, but they refer to slightly different aspects of data processing.
Live data connection:
In the context of data connections, "live" implies that the data is continuously updated and reflects the current state of affairs. When you establish a live connection, Grafieks retrieves data from the source whenever you interact with the reports and dashboards.
Real-Time data connection:
A real-time data connection, from a data streaming perspective, involves the continuous and immediate flow of data from a source to a destination, with minimal latency. In data streaming, information is processed and transmitted as it is generated, allowing for instant updates and analysis.
Upon establishing a real-time connection, Grafieks reports subscribe to channels/data sources to receive data that has been published into those channels/data sources, employing PUB/SUB mechanics.