Problems
From the last month
SQLAlchemy 1.4 PostgreSQL N+1 query for conditional COUNT(*)
python sqlalchemy n-plus-one postgresql performance 112 tokens
SQLAlchemy single-row UPDATE on hot row canceled by PostgreSQL statement_timeout
python postgresql sqlalchemy lock-contention statement-timeout 103 tokens
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 `
python sqlalchemy pytest postgresql timestamps 134 tokens
SQLAlchemy 2.0 SAWarning: utcnow does not set 'inherit_cache' with sqlalchemy-utc
python sqlalchemy sqlalchemy-utc inherit_cache sawarning 99 tokens
SQLAlchemy: InvalidRequestError "Can't operate on closed transaction" with BeanQueue background jobs
python sqlalchemy beanqueue postgres background-jobs 284 tokens
Earlier
SQLAlchemy: Per-row ORM deletes in loop hit statement_timeout on Render Postgres with cascading UoW deletes
python sqlalchemy postgres render performance 38 tokens
SQLAlchemy lazy-loading attributes raise 'Can't operate on closed transaction' within exception handler
sqlalchemy orm lazy-loading error-handling python 264 tokens
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
python sqlalchemy savepoint transaction postgres 121 tokens
pytest-alembic fails test_model_definitions_match_ddl after adding NOT NULL JSONB column with server_default
python alembic pytest-alembic sqlalchemy postgres 200 tokens
SQLAlchemy TypeDecorator with TypeID causes equality comparison failures between TypeID objects and strings
python sqlalchemy typeid typedecorator equality 174 tokens
Alembic pytest-alembic fails on custom ObjID PK: phantom table comment diff
python alembic pytest-alembic sqlalchemy migration-testing 158 tokens