Notes
Short technical notes: one problem, one answer, and how it was found.
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.
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.