Blog
Thoughts on engineering and technology
Optimizing Spatial Queries: When Polygon Simplification Helps (and When It Doesn't)
Benchmarking polygon simplification for PostGIS spatial queries across 200 divisions — where it shines, where it hurts, and why.
SQL in the Browser: Querying 2.3 Billion Records with Zero Backend
An experiment with Claude, open data, and a SQL-first approach to frontend development - querying Overture Maps directly from S3 using DuckDB-WASM.