Hacker News new | ask | show | jobs
by cpa 469 days ago
Nice, I did not know about polygonToCellsExperimental.

As for DuckDB & rtree, it's alas not a replacement of postgis yet and the indices cannot be used (yet) in joins. In fact, I even have workflows where I iterate over rows in python and run duckdb queries one after the other rather than joining in just one query because of this very issue.