Problems
From the last month
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
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