Background
I run more than twenty small sites as a solo developer. Publishing is automated; looking at the results was not. Google Analytics and Search Console are both fine for one site, but opening two consoles per site, aligning the date ranges, and remembering yesterday's number does not scale to twenty. I stopped doing it after three days.
So I put a small server on a Mac mini at home and started pushing every site's numbers to it a few times a day. It uses only the Python standard library, http.server and sqlite3. There is no pip install step, no framework, and nothing to keep updated.
This post is about the storage design, and specifically about one decision that paid off and one bug it caused.
How it works
