In June 2025, a blog post shares various useful resources for developers, including insights on Postgres performance issues with COUNT queries and the introduction of new tools like Leaflet v2.0 alpha and cqlalchemy. These tools facilitate common data handling tasks, improve file organization, and enhance web mapping capabilities. The post also discusses the storage of STAC catalogs in GeoParquet format and a related authentication proxy. Overall, it emphasizes advancements in technology for efficient data processing and management.
Why COUNT(*) can be slow in Postgres: a good delve into how Postgres works 'under the hood' and why that means that counting rows can sometimes be quite time-consuming.
Leaflet v2.0 alpha: an alpha version of a new major version of Leaflet, the web mapping library. I actually tend to use MapLibre these days, but I prefer the Leaflet API.
Collection
[
|
...
]