stac-utils/pgstac

View on GitHub

Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL

Stars: 223
Forks: 57
Open beginner issues: 0
Indexed issues: 59

Dominant language: PLpgSQL
License: MIT
Last GitHub push: Jul 21, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

59 open issues indexed

Queued query errors leak into later successful history rows Open

Difficulty 2/5 1-3 hours Newbie friendliness 76/100

stac-utils/pgstac#487 · Opened Sep 16, 2026
Allow building/updating queryable indexes without locking the table. Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

stac-utils/pgstac#486 · Opened Sep 15, 2026
Support index-field to create a GIN index Open

Difficulty 3/5 1-2 days Newbie friendliness 58/100

stac-utils/pgstac#484 · 2 comments · 1 reaction · Opened Sep 10, 2026
Resolve dotted (nested) queryable names Open

Difficulty 3/5 1-2 days Newbie friendliness 68/100

stac-utils/pgstac#483 · 2 comments · 1 reaction · Opened Sep 10, 2026
Published container image uses expired Bullseye security metadata Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

stac-utils/pgstac#481 · Opened Sep 8, 2026
pypgstac migrate from 0.9.8 to 0.9.11 took 5+ hours to run Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

stac-utils/pgstac#479 · 2 comments · Opened Aug 25, 2026
Deleting collection with items returns 500 Internal Server Error using pgstac_ingest user Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

stac-utils/pgstac#475 · 6 comments · Opened Aug 4, 2026
missing docker image for v0.9.12 Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

stac-utils/pgstac#474 · 2 reactions · Opened Aug 3, 2026
Free-text searches with minus (-) and plus (+) signs do not behave as expected Open

Difficulty 2/5 1-3 hours Newbie friendliness 76/100

stac-utils/pgstac#459 · Opened Jul 1, 2026
Unable to query/filter on start_datetime property after migrating from 0.8.6 to 0.9.6 Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

stac-utils/pgstac#452 · 2 comments · Opened Jun 5, 2026
Query with bbox crossing antimeridian does not work as expected Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

stac-utils/pgstac#428 · 5 comments · 1 reaction · Opened Apr 27, 2026
Feature request - add CLI/support to export static catalog Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

stac-utils/pgstac#405 · Opened Feb 19, 2026
DB connections are not reset after closing Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

stac-utils/pgstac#401 · Opened Jan 26, 2026
The saga of migrating from an existing deployment from pgstac:v0.9.1 to pgstac:v0.9.2 - Chapter I. Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

stac-utils/pgstac#393 · 1 comment · Opened Nov 21, 2025
`/search` with `?limit` fails with same item ID in different collections Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

stac-utils/pgstac#392 · 1 reaction · Opened Nov 19, 2025
Deleted-then-recreated collections don't always update items relation table name Open

stac-utils/pgstac#389 · 2 comments · 1 assignee · Opened Oct 31, 2025
Add versioning for collection item_assets Open

stac-utils/pgstac#388 · 2 comments · 1 assignee · Opened Oct 23, 2025
collection filtering on nested properties does not work Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

stac-utils/pgstac#385 · 1 reaction · Opened Sep 11, 2025
High Latency and DB Locks on Bulk Deletion Endpoint Open

Difficulty 4/5 3-5 days Newbie friendliness 32/100

stac-utils/pgstac#381 · 4 comments · Opened Aug 25, 2025
Add support for Named Saved Queries Open

stac-utils/pgstac#374 · 1 comment · 2 reactions · 1 assignee · Opened Jun 12, 2025
Add a function to create a blank collection. Open

stac-utils/pgstac#373 · 1 reaction · 1 assignee · Opened Jun 12, 2025
Free-text search parameter 'q' only works for collection search. Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

stac-utils/pgstac#371 · 4 comments · Opened May 14, 2025
item.pop("partition") leads to KeyError after retry Open

Difficulty 2/5 1-3 hours Newbie friendliness 62/100

stac-utils/pgstac#364 · Opened Mar 28, 2025
Using Iterable with @retry leads to silent data corruption Open

Difficulty 3/5 1-2 days Newbie friendliness 30/100

stac-utils/pgstac#363 · 1 comment · Opened Mar 28, 2025
Store and advertise Collections `queryables` Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

stac-utils/pgstac#350 · Opened Feb 18, 2025
pgstac is not FIPS compliant Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

stac-utils/pgstac#348 · 4 comments · 1 reaction · Opened Feb 6, 2025
Drop Python 3.8 support Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

stac-utils/pgstac#343 · Opened Jan 31, 2025
Database connections are never closed Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

stac-utils/pgstac#340 · 5 comments · Opened Jan 23, 2025
missing previous link when `offset>0` but `limit > number_matched` Open

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

stac-utils/pgstac#338 · Opened Jan 10, 2025
Feature Request: `pypgstac` CLI command to list/update`pgstac_settings` Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

stac-utils/pgstac#337 · 1 comment · 2 reactions · Opened Jan 8, 2025
Allow `null` geometries for Items Open

enhancement

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

stac-utils/pgstac#325 · 4 comments · 1 reaction · Opened Nov 26, 2024
Continuous integration should run tests more often Open

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

stac-utils/pgstac#321 · Opened Nov 19, 2024
PgstacCLI.loadextensions "UPDATE pgstac.stac_extensions" does not work Open

Difficulty 3/5 1-2 days Newbie friendliness 38/100

stac-utils/pgstac#312 · 1 reaction · Opened Oct 17, 2024
Deadlock between search requests and ingestion process Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

stac-utils/pgstac#311 · 1 comment · Opened Oct 14, 2024
[Feature request] Adding daily partitions Open

stac-utils/pgstac#307 · 6 comments · 1 assignee · Opened Sep 20, 2024
Windows UTF-8 Encoding Open

Difficulty 2/5 1-3 hours Newbie friendliness 55/100

stac-utils/pgstac#301 · Opened Aug 30, 2024
`_where` and `orderby` fields not being populated in `search` table, `search_wheres` not populated at all Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

stac-utils/pgstac#292 · 2 comments · 1 reaction · Opened Aug 1, 2024
Failed to detect the target database version when loading collection and items Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

stac-utils/pgstac#290 · 5 comments · Opened Jul 22, 2024
Introduce new load method to extend existing STAC items Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

stac-utils/pgstac#288 · Opened Jul 11, 2024
pypgstac load items partially without exceptions Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

stac-utils/pgstac#285 · Opened Jul 1, 2024
Eliminate redundant partition stats update Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

stac-utils/pgstac#283 · 1 comment · Opened Jun 29, 2024
Add support for loading from pystac objects Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 42/100

stac-utils/pgstac#282 · 3 comments · 1 reaction · Opened Jun 26, 2024
Syntax error from temporal_op_query Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

stac-utils/pgstac#281 · 1 comment · Opened Jun 23, 2024
Ensure proper handling of geometries passed in that cross the antimeridian Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 20/100

stac-utils/pgstac#261 · 2 comments · Opened Apr 24, 2024
Aggregation Extension Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

stac-utils/pgstac#257 · 1 comment · Opened Apr 17, 2024
Intermittent data ingestion issue Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

stac-utils/pgstac#222 · 5 comments · Opened Oct 14, 2023
Optimizing query performance during ingestion process Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

stac-utils/pgstac#221 · 3 comments · Opened Oct 14, 2023
Dynamic queryables Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

stac-utils/pgstac#209 · 3 comments · Opened Sep 5, 2023
CRUD API's for Queryables in pypgstac Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

stac-utils/pgstac#198 · 2 comments · Opened Aug 15, 2023
Adding a queryable for time queries Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

stac-utils/pgstac#194 · 1 comment · Opened Jul 6, 2023

stac-utils/pgstac

Get new issues in your inbox