4 ms·
Mildly related: can anyone recommend a time series database that supports easy aggregation by week (with the ability to configure the start of the week) and mon
by shrx 3y ago
Mildly related: can anyone recommend a time series database that supports easy aggregation by week (with the ability to configure the start of the week) and month? I'm looking for something to switch from InfluxDB which I'm currently using. The linked article is using Prometheus which also doesn't appear to support this functionality.
- cocire 3y agowould love an answer to this as well! something with great Python (Flask, maybe even SQLAlchemy) support would be cool too
- sohooo 3y agoYou could take a look at Postgres + TimescaleDB extension, which offers a nice time_bucket() function on its hypertables[1]. You can also materialize using continuous aggregates („self updating“ materialized views). 1: https://docs.timescale.com/api/latest/hyperfunctions/time_bucket/ https://docs.timescale.com/api/latest/hyperfunctions/time_bu...
- shrx 3y agoThanks, this looks exactly what I want. Sensible interval origins [1] too (January 1, 2000 for months and years, and January 3 2000, a Monday, for weeks) and also configurable. [1] https://docs.timescale.com/use-timescale/latest/time-buckets/about-time-buckets/ https://docs.timescale.com/use-timescale/latest/time-buckets...