v0.0.4 🧹 Performance, Correctness & Pruning
Important
Network total graph now shows 30 days. The LIMIT was too aggressive — 720 rows at 15-min intervals only covered 7.5 days. Upped to 2880 rows.
🐍 Python Backend
- movers endpoint — Was using a single global timestamp instead of per-country lookups. Fixed with per-country subqueries.
- comparison endpoint — Had no LIMIT, could return 35K+ rows. Now capped at 720.
- query_trends — Parameterized the SQL instead of f-string interpolation.
🦀 Rust Backend
- movers_detailed — ~3000 individual queries per request. Now batches each window into one query.
- at_risk — Same N+1 pattern. Batched into one query.
- country_stats — Was fetching 6 hours of data (24 rows). Now fetches 96 rows for full 24h volatility.
- 24h moving average — Integer division was truncating. Now uses float division with rounding.
⏰ Pruning
- prune_old_data.py — Referenced in crontab for years but never existed. Created it.
🖥️ Frontend
- setInterval leak — Every refresh spawned a new timer. ~288 redundant timers after 24h. Now clears properly.
- Volatility API calls — 100 individual requests per page load. Removed live volatility from mover tables.
- Timezone staleness — Poll freshness compared UTC vs local browser time. Now uses consistent UTC math.
🔧 Poller
- JWT error handling — Missing/empty token now logs a clear error instead of failing silently.