David Bitner

didn't quite get there today, but I'll have something that cleans a lot of the postgres stuff up tomorrow

you kind of need to do the one extra in some way or another, because you need to know if there are anymore records. definitely would want to wrap that...

It looks like it has something to do with src/pgstac/pgstac.sql being a symlink that is set to link to the latest version in the migrations file. ``` ls -ltrh src/pgstac...

Right now, tracking down Windows issues isn't something I have time for, but I am very happy to take any PRs to increase support for Windows. Windows should have absolutely...

I don't use our have access to windows. I'm happy to review any PRs that fix this issue, but I can't help track it down. On Mon, Jul 22, 2024,...

@drnextgis Hah, I actually prefer the formatting with the line separators as, to me, it's easier to see the full query when the query gets large. Do you have any...

My first guess would be that the search_path is not getting set correctly when connecting to the database. Can you try setting the search_path as a setting on the role...

No. There is no spatial partitioning possible and it would be a huge effort to add. The partitioning options in pgstac (initial partition by collection and optional sub-partitions by month...

Sorry, we don't have any benchmarks, but based on other experience, I would not expect spatial partitioning to make any difference (and actually, there is a good chance it would...

It should probably be a collections array field rather than singular to accommodate geoparquet that may have Items from multiple collections.