eai-core-infra

Python package to manage core Pulumi infrastructure resources for ExtensibilityAI-provided deployments.

Install

From PyPI:

pip install eai-core-infra
# or
uv add eai-core-infra

Database pooler (PgBouncer)

Opt-in per app stack with <cloud>.db.pooler. Absent or enabled: false changes nothing. An app owns a pooler in its namespace:

cloud:
  db:
    flags: {max_connections: "100"}   # optional; enables the connection-budget check
    pooler:
      enabled: true
      replicas: 2                      # fixed; never autoscaled
      defaultPoolSize: 4               # pool for DATABASE_NAME
      pools: {api: 8, workers: 24}     # named pools: DATABASE_POOL_<NAME>=<db>__<name>
      clients:                         # other apps' DB users allowed through
        - {user: my-consumer, namespace: my-consumer, maxConnections: 6}

Or it is a client of another app's pooler:

cloud:
  db:
    pooler: {enabled: true, namespace: owner-app, pool: workers}

Server connections: replicas × (Σ pool sizes + reservePoolSize per pool + Σ client maxConnections). With db.flags.max_connections, parsing checks that this, plus directReserve and 3 superuser connections, fits.
Transaction mode (the default) doesn't support session state across transactions:
- no session SET (use SET LOCAL);
- no session advisory locks (use pg_advisory_xact_lock);
- no LISTEN/NOTIFY and no WITH HOLD cursors.
Protocol-level prepared statements work (maxPreparedStatements). Don't hold a transaction open across slow work.
Migrations and admin connect directly, through DATABASE_DIRECT_HOST and DATABASE_DIRECT_PORT.

The infra library that owns the stack (e.g. eai-web-app-infra) calls create_pgbouncer and writes the app-env keys.

Test

uv sync --extra dev
uv run pytest

Pre-commit

Hooks mirror CI lint and tests (ruff check, pytest):

uv tool install pre-commit   # once
pre-commit install
pre-commit run --all-files   # optional manual run

License

Apache-2.0

Metadata

Release files for eai-core-infra 1.0.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for eai-core-infra 1.0.0
File	Size	Uploaded
eai_core_infra-1.0.0.tar.gz	657.3 kB	Oct 6, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for eai-core-infra 1.0.0
File	Interpreter	ABI	Platform	Reset
eai_core_infra-1.0.0-py3-none-any.whl 670.2 kB Oct 6, 2026	Python 3	none	any	Details

Total release size: 1.3 MB

Release files / eai_core_infra-1.0.0.tar.gz

Download URL	eai_core_infra-1.0.0.tar.gz
Size	657.3 kB
Tags	Source
SHA-256 checksum How to use checksums	`489bc5cf5965dd1fd59e89634fa833dce0ca20e23a9e68323865e44727424d92`
BLAKE2b-256 checksum How to use checksums	`615ce7b690051f0ae3acc013f1483c3b41c96ee86f262cef2df71bb06098133d`
Upload date	Oct 6, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/ExtensibilityAI/eai-core-infra
Publishing commit: github.com/ExtensibilityAI/eai-core-infra/tree/e4a569582a9f9e9aff76bb9d40757d82d883108f

Workflow

Publishing configuration: github.com/ExtensibilityAI/eai-core-infra/blob/e4a569582a9f9e9aff76bb9d40757d82d883108f/.github/workflows/publish-pypi.yml
Publishing logs: github.com/ExtensibilityAI/eai-core-infra/actions/runs/37524884422/attempts/1

Artifact

Subject: eai_core_infra-1.0.0.tar.gz
SHA-256 checksum: 489bc5cf5965dd1fd59e89634fa833dce0ca20e23a9e68323865e44727424d92 Verifying attestations

Release files / eai_core_infra-1.0.0-py3-none-any.whl

Download URL	eai_core_infra-1.0.0-py3-none-any.whl
Size	670.2 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`c978e7fc9355c400c601158e8ed11bf54fca4c8879588a720eff53737d872c1d`
BLAKE2b-256 checksum How to use checksums	`ca67a93ade50e49ecde505065388d566e55f30025091e05d9875528f7a025122`
Upload date	Oct 6, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/ExtensibilityAI/eai-core-infra
Publishing commit: github.com/ExtensibilityAI/eai-core-infra/tree/e4a569582a9f9e9aff76bb9d40757d82d883108f

Workflow

Publishing configuration: github.com/ExtensibilityAI/eai-core-infra/blob/e4a569582a9f9e9aff76bb9d40757d82d883108f/.github/workflows/publish-pypi.yml
Publishing logs: github.com/ExtensibilityAI/eai-core-infra/actions/runs/37524884422/attempts/1

Artifact

Subject: eai_core_infra-1.0.0-py3-none-any.whl
SHA-256 checksum: c978e7fc9355c400c601158e8ed11bf54fca4c8879588a720eff53737d872c1d Verifying attestations