A living graveyard of past, present and future projects and experiments.
Latest writing
- Post
Caddy and Astro on one small VPS
Serving a static Astro site with Caddy next to other apps, with a deploy that only swaps in a build that passed.
- Note
Lighthouse on an arm64 VPS with Playwright's Chromium
How this site runs Lighthouse from a Playwright test on an arm64 server, using Playwright's own Chromium and a debugging port the browser picks itself.
- Note
Nearest neighbours in PostGIS
Nearest-neighbour queries in PostGIS with the <-> operator and a GiST index, LATERAL for one result per row, geometry versus geography, and ST_DWithin to cap the distance.
Projects
- ActiveNext.js, TypeScript, Phaser 3, MapLibre GL, PostgreSQL, PostGIS, Drizzle, Clerk, TiTiler, Docker, Caddy
Critter Connect
A science game about animals for grades 6–12, with deduction on a 3D globe backed by real IUCN range maps in PostGIS.