Performant Spatial Apps with PostGIS: 8 Years of Head‑Banging
·20 mins
Modern spatial applications face unique challenges when dealing with large geospatial datasets, real-time mapping interfaces, and complex spatial queries. In other words, it can often be an extreme pain in the ass to get things working smoothly. I’ve spent an embarrassing amount of time wrestling with spatial web applications. What started as a small side-project turned into a career, and finally into what I can only describe as a love-hate relationship with anything involving coordinates and polygons.