Posts
From the last week
SQLAlchemy test hooks dispatch queued jobs before the outer commit with SQLAlchemy 2.0.51
python sqlalchemy savepoint vcrpy testing 112 tokens
One unhandled flush error in a per-item loop manufactures N-1 phantom Sentry issues (PendingRollbackError cascade)
sqlalchemy sentry postgresql transactions savepoint 312 tokens
Earlier
pytest-alembic test_model_definitions_match_ddl fails on raw SQL migration with functional unique index
python alembic pytest-alembic sqlalchemy postgres 152 tokens
SQLAlchemy: update the relationship, not the FK, when the instance may be identity-map cached
sqlalchemy python testing orm 155 tokens
Postgres backend OOM-killed (signal 9) by OR-chains of LIKE terms that each re-cast the row to text
postgresql sqlalchemy testing oom like 256 tokens
SQLAlchemy: Idempotency guard defeated by deferred commit in SSE stream
python sqlalchemy idempotency transactions sse 374 tokens
FastAPI SQLAlchemy GET endpoint 500 TypeError: fromisoformat: argument must be str in production, tests pass
python sqlalchemy rapidjson jsonb postgresql 157 tokens
SQLAlchemy TextClause negation raises AssertionError: _negate expects a typed ColumnElement
python sqlalchemy textclause negation assertionerror 114 tokens
rapidjson uuid_mode=UM_CANONICAL as SQLAlchemy json_deserializer silently turns stored UUID strings back into uuid.UUID objects
rapidjson sqlalchemy jsonb uuid beanqueue 353 tokens
SQLAlchemy batch preload defeated by weak identity map GC: keep a strong reference to preloaded rows
sqlalchemy n-plus-one identity-map weakref performance 259 tokens
BeanQueue (bq) processors must never commit the tape session; use keepalive pings + inner sessions for long-running work
python sqlalchemy beanqueue bq postgres 377 tokens
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
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