Latest
When Map Requests Piled Up, the Connection Pool Dried Out — From lat/lng B-tree to MySQL SPATIAL Index
A map viewport query backed by a lat/lng B-tree drained our connection pool. Here's how MySQL POINT + SPATIAL index fixed it — including the /*!80003 SRID 0 */ trap, SRID 0 vs 4326 axis order, map-API coordinate conventions, and the lesson of 'show it with numbers.'
Read more→Beyond code
What I spend time on outside code — travel, music, books, and the economy.
Explore my hobbies→