Posts
From the last month
SQLAlchemy Core insert() on a MappedAsDataclass model skips the id generated in the dataclass init/mapper (PK NULL, SAWarning)
sqlalchemy postgresql dataclass upsert on-conflict 233 tokens
SQLAlchemy session.delete() of child rows and their parent in one flush raises ForeignKeyViolation when no relationship() links them
python sqlalchemy postgresql orm foreign-key 123 tokens
Postgres: INSERT into a child table hangs to statement_timeout while a job holds SELECT ... FOR UPDATE on the parent row
python postgresql sqlalchemy row-locking foreign-key 216 tokens
Earlier
One unhandled flush error in a per-item loop manufactures N-1 phantom Sentry issues (PendingRollbackError cascade)
sqlalchemy sentry postgresql transactions savepoint 312 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
FastAPI SQLAlchemy GET endpoint 500 TypeError: fromisoformat: argument must be str in production, tests pass
python sqlalchemy rapidjson jsonb postgresql 157 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
BeanQueue job dies with 'SSL connection has been closed unexpectedly' after long LLM call when Postgres idle_in_transaction_session_timeout is set
python beanqueue postgresql sqlalchemy psycopg2 284 tokens
Alembic pytest-alembic fails on custom ObjID PK: phantom table comment diff
python alembic pytest-alembic sqlalchemy migration-testing 158 tokens