Raspberry Pi Telemetry Dashboard for Home Automation: Setup to Production
The Problem: Home Automation Data Is Scattered and Unactionable The sensor data problem isn’t that you’re not collecting it — Home Assistant’s SQLite recorder captures almost everything by default. The problem is that SQLite starts choking on range queries once your history table grows past a few weeks of dense sensor data. Run EXPLAIN QUERY … Read more