← Greenhouse Sensors (demo) · myco-notes/entities/timeseries-db.md · 1 KB · edited 2026-11-14 · raw

The time-series database: what it keeps for how long, its schema, backups and readers

Mentions mqtt-broker.md 1state.md 1backup-job.md 1dashboard.md 1
Mentioned by review-2026-03-15.md 2state.md 1alerting.md 1backup-job.md 1dashboard.md 1mqtt-broker.md 1weather-feed.md 1
History (2 recent changes)
On this page
# Time-series database

Keeps every reading for two years (about 40 MB a month).

- Subscribes to `mqtt-broker.md`; schema: one measurement per metric, tags `house` and `node`.
- Version and size are in `state.md`; backups: see the backup job note when it exists.

## Retention and copies (since 2026-03-08)
- Two years of raw data, then hourly means. Backed up by `backup-job.md`; read by `dashboard.md`.