Max Gabrielsson

You can pass the definition of the coordinate system into ST_Transform (e.g. projjson, WKT2, or projstring) as well, it does not need to be a pre-defined identifier in the projection...

Hi! Thanks for opening this issue! There's couple of things at play here. Neither `ST_Union_Agg` or `array_agg` are able to spill intermediate state to disk as they are "variable size"...

Hello! > As I have enough RAM that the index can totally fit in the RAM, I don't understand why it's slower when I run it when database is persisted....

Index updates are currently implemented as `DELETE` + `INSERT`, there is no dedicated callback.

Hello! `reach_id` seems to be the FID column, which DuckDB doesn't output, see #213. Although we should probably revisit this soon as there really isn't a good reason anymore why...

Will revisit this soon!

Hello! Building and distributing the spatial extension on all supported platforms is a lot of work and generally extremely time consuming to debug. Since we already had a bunch of...

Hello! I've now enabled musl builds in #586 so we they should arrive in the nightly builds soon!

Hello! Just had a quick look at this, it seems that the `` join condition is the culprit as it turns the query plan from a `HASH JOIN` (fast) into...

With the above changes, the final query plan becomes: ``` ┌─────────────────────────────┐ │┌───────────────────────────┐│ ││ Physical Plan ││ │└───────────────────────────┘│ └─────────────────────────────┘ ┌───────────────────────────┐ │ PROJECTION │ │ ──────────────────── │ │ city_a │ │ city_b...