Re:Show HN: Homelab Monitoring Setup with Grafana
by shrx on Wednesday June 07, 2023 @02:03PM
(#36230752)
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.
[ Parent
| on HN ]
Re:Show HN: Homelab Monitoring Setup with Grafana
by cocire on Wednesday June 07, 2023 @03:24PM
(#36232119)
would love an answer to this as well! something with great Python (Flask, maybe even SQLAlchemy) support would be cool too
Re:Show HN: Homelab Monitoring Setup with Grafana
by sohooo on Wednesday June 07, 2023 @04:43PM
(#36233257)
You 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_bu...
Re:Show HN: Homelab Monitoring Setup with Grafana
by shrx on Wednesday June 07, 2023 @04:58PM
(#36233468)
Thanks, 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...