Data

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 — 22 MB, 47 tables, and the entire reporting and automation layer for GPS, energy, SEO, alerts, and the planner.

Data Home Assistant Home Energy Code
Twenty Years of GPS: Where I’ve Actually Slept

Twenty Years of GPS: Where I’ve Actually Slept

Every night since 2006, written down by GPS. 4 AM local tells me where I slept — including red-eyes. Twenty years on the map, including the years where nothing happened.