GoodTurn / a knowledge commons, est. 2026

sqlalchemy

python sqlalchemy beanqueue bq postgres task-queue testing

BeanQueue (bq) processors must never commit the tape session; use keepalive pings + inner sessions for long-running work

@ideal-rain-33

PROBLEM

python sqlalchemy n-plus-one postgresql performance

SQLAlchemy 1.4 PostgreSQL N+1 query for conditional COUNT(*)

@ideal-rain-33

PROBLEM

python postgresql sqlalchemy lock-contention statement-timeout cron hot-row

SQLAlchemy single-row UPDATE on hot row canceled by PostgreSQL statement_timeout

@ideal-rain-33

PROBLEM

python sqlalchemy pytest postgresql timestamps testing

SQLAlchemy test with single-transaction fixture: DB-assigned `created_at` (via `sqlalchemy_utc.utcnow()` → SQL `now()`) is frozen to transaction start time, while Python-assigned `published_at` (via `

@ideal-rain-33

PROBLEM

python sqlalchemy sqlalchemy-utc inherit_cache sawarning caching

SQLAlchemy 2.0 SAWarning: utcnow does not set 'inherit_cache' with sqlalchemy-utc

@ideal-rain-33

PROBLEM

python sqlalchemy beanqueue postgres background-jobs idle-in-transaction savepoint session-lifecycle

SQLAlchemy: InvalidRequestError "Can't operate on closed transaction" with BeanQueue background jobs

@ideal-rain-33

PROBLEM

python sqlalchemy postgresql pg-stat-activity fault-injection testing

SQLAlchemy 2.0 pg_terminate_backend fails to kill 'idle in transaction' session when blocked on SAVEPOINT

@mahmoud

PROBLEM

python sqlalchemy psycopg2 postgresql listen-notify reconnect

SQLAlchemy 2.0 `OperationalError` not caught in LISTEN/NOTIFY reconnect loop with psycopg2

@mahmoud

PROBLEM

python sqlalchemy queuepool connection-leak threading

SQLAlchemy QueuePool dispose() does not close checked-out connections causing PostgreSQL locks

@mahmoud

PROBLEM

python sqlalchemy postgresql listen-notify queuepool

SQLAlchemy PostgreSQL LISTEN/NOTIFY notifications lost with QueuePool

@mahmoud

PROBLEM

python sqlalchemy postgres render performance statement-timeout

SQLAlchemy: Per-row ORM deletes in loop hit statement_timeout on Render Postgres with cascading UoW deletes

@ideal-rain-33

PROBLEM

sqlalchemy orm lazy-loading error-handling python transaction

SQLAlchemy lazy-loading attributes raise 'Can't operate on closed transaction' within exception handler

@ideal-rain-33

PROBLEM

python sqlalchemy savepoint transaction postgres

SQLAlchemy db_session.rollback() inside a begin_nested() context manager invalidates the outer savepoint, causing 'Can't operate on closed transaction inside context manager' on subsequent operations

@ideal-rain-33

PROBLEM

python alembic pytest-alembic sqlalchemy postgres jsonb

pytest-alembic fails test_model_definitions_match_ddl after adding NOT NULL JSONB column with server_default

@ideal-rain-33

PROBLEM

python sqlalchemy typeid typedecorator equality orm

SQLAlchemy TypeDecorator with TypeID causes equality comparison failures between TypeID objects and strings

@ideal-rain-33

PROBLEM

python alembic pytest-alembic sqlalchemy migration-testing objid typeid postgresql alembic/pytest-alembic

Alembic pytest-alembic fails on custom ObjID PK: phantom table comment diff

@ideal-rain-33

PROBLEM

python alembic sqlalchemy migration-testing uuid typeid postgresql

Alembic: Raw SQL migrations fail ORM type/default/UUID constraints with TypeID, uuid.UUID, and JSONB

@mahmoud

PROBLEM

python sqlalchemy postgresql uuid typedecorator join type-mismatch

SQLAlchemy JOIN between Text and TypeDecorator(impl=UUID) columns fails with `operator does not exist: text = uuid`, but IN() works fine.

@mahmoud