PgSTAC backend for stac-fastapi, the FastAPI implementation of the STAC API spec
stac-fastapi-pgstac is an HTTP interface built in FastAPI. It validates requests and data sent to a PgSTAC backend, and adds links to the returned data. All other processing and search is provided directly using PgSTAC procedural sql / plpgsql functions on the database. PgSTAC stores all collection and item records as jsonb fields exactly as they come in allowing for any custom fields to be stored and retrieved transparently.
stac-fastapi-pgstac depends on pgstac database schema and pypgstac python package.
| stac-fastapi-pgstac Version | pgstac |
|---|---|
| 2.5 | >=0.7,<0.8 |
| 3.0 | >=0.8,<0.9 |
| >=4.0 | >=0.8,<0.10 |
PgSTAC is an external project and may be used by multiple front ends. For Stac FastAPI development, a Docker image (which is pulled as part of the docker-compose) is available via the Github container registry. The PgSTAC version required by stac-fastapi-pgstac is found in the setup file.
While the STAC Sort Extension is fully supported, PgSTAC is particularly enhanced to be able to sort by datetime (either ascending or descending). Sorting by anything other than datetime (the default if no sort is specified) on very large STAC repositories without very specific query limits (ie selecting a single day date range) will not have the same performance. For more than millions of records it is recommended to either set a low connection timeout on PostgreSQL or to disable use of the Sort Extension.
To configure stac-fastapi-pgstac to hydrate search result items at the API level, set the USE_API_HYDRATE environment variable to true. If false (default) the hydration will be done in the database.
| use_api_hydrate (API) | nohydrate (PgSTAC) | Hydration |
|---|---|---|
| False | False | PgSTAC |
| True | True | API |
There is a Python utility as part of PgSTAC (pypgstac) that includes a migration utility. To use:
pypgstac migrateInstall the packages in editable mode:
We recommand using uv as project manager for development.
See https://docs.astral.sh/uv/getting-started/installation/ for installation
uv sync --devTo run the tests:
uv run pytestSee CONTRIBUTING for detailed contribution instructions.
See RELEASING.md.
stac-fastapi-pgstac was initially added to stac-fastapi by developmentseed. In April of 2023, it was removed from the core stac-fastapi repository and moved to its current location (http://github.com/stac-utils/stac-fastapi-pgstac).