Time series databases

Intro

https://itnext.io/migrating-from-relational-databases-to-time-series-databases-9f059a3e34cb

Interesting tech

https://citrusvanilla.medium.com/introducing-tinyflux-the-tiny-time-series-database-for-python-based-iot-analytics-applications-c3ef3c3bedf
“By combining the simplicity of TinyDB with the concepts of InfluxDB, TinyFlux represents the middle ground in time series data stores in which you can enjoy the streamlined API of a mature database interface without the need for provisioning and maintaining new instances to host your data.”

https://stackoverflow.com/questions/65422890/how-to-use-time-series-with-sqlite-with-fast-time-range-queries

https://sqlite.org/rtree.html

“LittleTable: A Time-Series Database and Its Uses” (https://meraki.cisco.com/wp-content/uploads/2022/06/lt-paper.pdf) (not free)

Docker + Prometheus: https://docs.docker.com/config/daemon/prometheus/

Measurements

Prometheus → 68 MB of RSS
Python process → 14 MB

#database

#data #database #docker

Page last modified: 2024-11-13 14:01:29