psycopg_pool ConnectionPool

Context managers for connections

%s parameterized queries

Transaction for batch event logging

Bulk insert for events

Transaction for archive operation

Pool shutdown cleanup

DATABASE_URL from environment

Dict row factory

Batched archival to avoid long locks

asyncpg pool with lifecycle

Bulk upsert for catalog import

Transaction for stock transfer

Stock validation before transfer

Async context managers for connections

$1/$2 parameterized queries

Server-side cursor for warehouse export

DATABASE_URL from environment

Pool timeout configuration

No SQL injection vectors

psycopg_pool ConnectionPool

Context managers for connections

Transaction for bulk scheduling

Efficient bulk insert

%s parameterized queries

Server-side cursor for patient history

Pool shutdown cleanup

DATABASE_URL from environment

Dict row factory for query results

max_lifetime or max_idle on pool

psycopg_pool for sync reports

asyncpg pool for async API

Correct placeholder per driver

Context managers for sync connections

Async context managers for async connections

Server-side cursor for cohort export

Transaction for batch order sync

Bulk update for order sync

Both pools cleaned up on shutdown

DATABASE_URL from environment

Dict row factory for psycopg reports

No SQL injection vectors

asyncpg pool with create_pool

Pool lifecycle management

Async context managers for connections

Bulk insert for event ingestion

$1/$2 parameterized queries

Transaction for daily summary generation

Server-side cursor for user activity

DATABASE_URL from environment

command_timeout on pool

No SQL injection vectors