The horizon that lost the west
A precomputed artifact served confidently wrong answers every evening - 20 of 64 horizon sectors were zero. How impossible geometry gave it away, and how a 13-hour rebuild became a 15-second deploy.
Notes
Engineering write-ups and anonymized case studies.
The API was broken, so I traced the map that worked
How geo-hazard's wildfire ingestion went from a WFS that returned SQL errors to live data - tracing the official EFFIS viewer to a different mapfile, a catalog of OGC quirks, and the asyncpg limit the first real payload found.
From a TLE to a contact window
What happens between downloading two lines of orbital elements and telling a ground station when a satellite will rise. SGP4, elevation masks and pass geometry.
Colophon
How this site is built, and why it ships almost no JavaScript.
A Postgres job queue instead of a message broker
How apsis runs scheduled jobs and a transactional outbox on plain PostgreSQL, and when I would not do it.