Reading data from a time series databases
A time series database, a type of NoSQL database, is optimized for time-stamped or time series data and provides improved performance, especially when working with large datasets containing IoT data or sensor data. In the past, common use cases for time series databases were mostly associated with financial stock data, but their use cases have expanded into other disciplines and domains. In this recipe you will explore three popular time series databases: InfluxDB, TimescaleDB, and TDEngine.
InfluxDB is a popular open source time series database with a large community base. In this recipe, we will be using InfluxDB's latest release as of this writing; that is, version 2.7.10. The most recent InfluxDB releases introduced the Flux data scripting language, which you will use with the Python API to query our time series data.
TimescaleDB, on the other hand, is an extension of PostgreSQL specifically optimized for time series data. It leverages...