<pb/>

Blog

Notes on building for the web, working with spatial data, and the things that break in between.

latest14 Feb 2026 · 6 min read

Finding the nearest rider without melting the database

The naive version loops every rider in Python. The version that survives production is a single spatial query with the right index behind it.

PostGISDjangoperformance
read it