beacon-server

dandri/beacon-server

Fork 0

mirror of https://github.com/MeshCore-Beacon/beacon-server.git synced 2026-10-20 12:11:58 +00:00

Commit Graph

Author	SHA1	Message	Date
MrAlders0n	98006a9364	feat(stats): serve historical stats from hourly rollups Stats endpoints read hourly rollup tables filled once per closed hour by one advisory-locked task, instead of materialized views that re-scanned every observation on each refresh. IATA-set tables give exact distinct counts for any IATA set or region. Cleanup holds raw rows for unrolled hours (up to 24h). Adds /stats/series; ingest keeps packet observation counts, observer last IATA, channel message counts and trace tag summaries. 001_baseline.sql is rewritten, so pre-release 2.0 databases must be recreated. See docs/historical-stats.md.	2026-10-02 07:43:56 -04:00
MrAlders0n	3ac4035942	refactor(db): flatten migrations into a 2.0.0 baseline 2.0.0 is a fresh deploy, so the 1.x chain becomes one schema file. Startup now refuses a pre-2.0.0 database instead of applying the baseline on top.	2026-09-30 21:37:28 -04:00

Author

SHA1

Message

Date

MrAlders0n

98006a9364

feat(stats): serve historical stats from hourly rollups

Stats endpoints read hourly rollup tables filled once per closed hour by one
advisory-locked task, instead of materialized views that re-scanned every
observation on each refresh. IATA-set tables give exact distinct counts for any
IATA set or region. Cleanup holds raw rows for unrolled hours (up to 24h).

Adds /stats/series; ingest keeps packet observation counts, observer last IATA,
channel message counts and trace tag summaries. 001_baseline.sql is rewritten,
so pre-release 2.0 databases must be recreated. See docs/historical-stats.md.

2026-10-02 07:43:56 -04:00

MrAlders0n

3ac4035942

refactor(db): flatten migrations into a 2.0.0 baseline

2.0.0 is a fresh deploy, so the 1.x chain becomes one schema file. Startup now refuses a pre-2.0.0 database instead of applying the baseline on top.

2026-09-30 21:37:28 -04:00