pgstac

pgstac copied to clipboard

Add partition_update_enabled option

3

We ingest images on a daily basis into the catalog and notice that using the `check_partition` function [here](https://github.com/stac-utils/pgstac/blob/1ea6c5df7cc79364e34ea9bee7693f9db2d922cd/src/pypgstac/python/pypgstac/load.py#L284C32-L284C47) significantly slows down the ingestion process. Since we have prior knowledge of...

drnextgis

Validation Error and Content Mismatch in Sentinel-2-L1C Item Definition JSON

3

Hello, I managed to create a collection definition json and a sample item json. The sample item was created using a script inspired by https://github.com/dlr-eoc/EOmetadataTool. Then I found the Sentinel-2-L2A...

MathewNWSH

CQL2 has evolved and the ILIKE operator was removed from the specification. pgstac still implements ILIKE. Instead there's now a function called CASEI for a similar purpose. (ACCENTI might also...

m-mohr

Occasional syntax errors from well formed search queries

1

This is quite a tricky one to reproduce. We are running pgstac in production and very occasionally get `pq: syntax error at end of input` errors from pgstac `search` queries....

mirober

scripts/install missing?

2

The contributing guide says: > Otherwise you'll need to install a local copy yourself by running scripts/install. There's no scripts/install as far as i can see.

m-mohr

Intermittent data ingestion issue

5

Are there any situations that might result in data not being ingested into the database following the successful invocation of [load_items](https://github.com/stac-utils/pgstac/blob/1ea6c5df7cc79364e34ea9bee7693f9db2d922cd/src/pypgstac/python/pypgstac/load.py#L586)? Concurrent ingestions or heavy database loads during the ingestion...

drnextgis

Optimizing query performance during ingestion process

3

I noticed that this query takes a long time during the ingestion process: ```sql SELECT tstzrange(min(datetime), max(datetime),'[]'), tstzrange(min(end_datetime), max(end_datetime), '[]') FROM _items_1 ``` If I'm not mistaken, it originates from...

drnextgis

Removing queryables indices

2

I notice that in [#210](https://github.com/stac-utils/pgstac/pull/210), `eo:cloud_cover` has been excluded from the list of queryables. Is there a function available to also remove the corresponding index from all partitions, or is...

drnextgis

Setting up time partitioning after initial data load

1

The documentation states that Partitioning needs to be set up before data is loaded. I'm curious if it's possible to set up time partitioning after the initial data load. I've...

drnextgis

Enable Strict Mode for Queryables / Search

9

Enable mode to only allow search properties that are in the queryables table. When a queryable has a range or enum, return an error when a search requests values outside...

bitner