Code

Two Databases, One Repo: How SQLite Glues This Site Together

Two Databases, One Repo: How SQLite Glues This Site Together

The 0-byte ghost.db fossil at content/data is a Ghost migration leftover. The one that actually runs this site lives one directory over — 13 MB, 44 tables, and the entire reporting and automation layer for GPS, energy, SEO, alerts, and the planner.

Data Home Assistant Home Energy Code
What My Battery Compares Every 30 Minutes

What My Battery Compares Every 30 Minutes

Most home batteries charge whenever the rate is cheap. Mine compares this cycle's cheapest slot against the next cycle's, the projected drain, the SOC-aware ceiling, and a forecast of tomorrow's solar — every 30 minutes.

solar energy Home Automation Home Energy Home Assistant Code