New blog post: how I shrank the Book Corners map payload from 13.85 MB to 7 KB, clustering 37,238 public bookcases with PostGIS and reusing the Django search queryset as a subquery. www.andreagrandi.it/posts/how-i-...
How I shrank the Book Corners map payload from 13.85 MB to 7 KB
The Book Corners map endpoint could return every library in a single 13.85 MB GeoJSON response. This is how I fixed it with server-side clustering in PostGIS, and the numbers measured in production be...
andreagrandi.it