render-lab-tasks-render-postgres
Nine tasks: postgres.query, execute, upsert, transaction, migrate,
setupVectorStore, upsertVectors, searchVectors, and deleteVectors.
Import render_lab_tasks_render_postgres.tasks for explicit registration.
Each operation exports an injectable async *_impl(ctx, input, *, deps=...).
Environment, read at first use:
| Variable | Meaning |
|---|---|
| DATABASE_URL | PostgreSQL URL, required; linked Render Postgres private URL is supported |
| DATABASE_SSL | true/require verifies TLS certificates, no-verify encrypts without verification; unset uses URL/driver options |
The async psycopg driver uses native $1 positional placeholders. Each invocation
closes its connection. Transactions roll back on exceptions and cancellation;
there are no driver retries. Durable tasks retry three times with 1s exponential
backoff. Arbitrary SQL writes can repeat after an ambiguous commit failure.
Generated upserts validate and quote identifiers, an intentional tightening from TypeScript's trusted-identifier interpolation. Schema-qualified table names are not accepted by generated operations; use explicit SQL in query/execute instead. Vector operations preserve the canonical id/content/metadata/embedding schema, finite-vector validation, bounded search limits, and guarded delete selectors.
Migration SQL and ledger inserts run in one transaction. Concurrent callers can race on the ledger read; PostgreSQL rolls back the losing transaction. Migration names must be unique. DDL requiring autocommit (such as CREATE INDEX CONCURRENTLY) does not belong in a migration transaction.
Results are JSON values: decimal/UUID values become strings, dates/times ISO strings, and binary values become Node-compatible Buffer-shaped JSON. Unknown custom driver objects and non-finite floats fail instead of escaping the task. These mappings intentionally define Python serialization where raw node-postgres objects were ambiguous. Live Postgres/pgvector/TLS checks remain in the backlog.
Installation
pip install render-lab-tasks-render-postgres==0.1.0
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file render_lab_tasks_render_postgres-0.1.0.tar.gz.
File metadata
- Download URL: render_lab_tasks_render_postgres-0.1.0.tar.gz
- Upload date:
- Size: 9.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
173284dafa587a5cc93e31a3bbdfdd3ab9c97f7ec9b53d2e72a0618e44e97b66
|
|
| MD5 |
8951fe4b288db83bb12f0ea5a1665c04
|
|
| BLAKE2b-256 |
590ebe04a9443f8b6a3eaa0413b36cc9e6afffd5ac53ca037e36a1f3f19501e2
|
Provenance
The following attestation bundles were made for render_lab_tasks_render_postgres-0.1.0.tar.gz:
Publisher:
publish.yml on render-lab/render-tasks-python
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
render_lab_tasks_render_postgres-0.1.0.tar.gz -
Subject digest:
173284dafa587a5cc93e31a3bbdfdd3ab9c97f7ec9b53d2e72a0618e44e97b66 - Sigstore transparency entry: 2767932488
- Sigstore integration time:
-
Permalink:
render-lab/render-tasks-python@b601664587ba5882dd7c8efabfc8908151008df6 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/render-lab
-
Access:
internal
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@b601664587ba5882dd7c8efabfc8908151008df6 -
Trigger Event:
workflow_dispatch
-
Statement type:
File details
Details for the file render_lab_tasks_render_postgres-0.1.0-py3-none-any.whl.
File metadata
- Download URL: render_lab_tasks_render_postgres-0.1.0-py3-none-any.whl
- Upload date:
- Size: 14.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
24203263f5b48f5d4338142d94006ed449bd6f3234c683121b58010e29b3e3dc
|
|
| MD5 |
0f6e7c961bf80407a85efbd35821a1e4
|
|
| BLAKE2b-256 |
b7086b40d3a947ac788aa31665f870281d6d933a4a94dd271ebc4f1150ac1c38
|
Provenance
The following attestation bundles were made for render_lab_tasks_render_postgres-0.1.0-py3-none-any.whl:
Publisher:
publish.yml on render-lab/render-tasks-python
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
render_lab_tasks_render_postgres-0.1.0-py3-none-any.whl -
Subject digest:
24203263f5b48f5d4338142d94006ed449bd6f3234c683121b58010e29b3e3dc - Sigstore transparency entry: 2767932507
- Sigstore integration time:
-
Permalink:
render-lab/render-tasks-python@b601664587ba5882dd7c8efabfc8908151008df6 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/render-lab
-
Access:
internal
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@b601664587ba5882dd7c8efabfc8908151008df6 -
Trigger Event:
workflow_dispatch
-
Statement type:
