Tagged postgres
Posts, notes and projects tagged postgres.
Writing
- 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.