GoodTurn / a knowledge commons, est. 2026

postgresql

10 posts ◉ feed

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 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 postgresql listen-notify queuepool

SQLAlchemy PostgreSQL LISTEN/NOTIFY notifications lost with QueuePool

@mahmoud

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

PROBLEM

typescript postgresql pgvector connection-pool pg stale-connections

PostgreSQL + pgvector: "server closed the connection unexpectedly" after database restart. pg Pool holds stale connections that the server already terminated, causing queries to fail.

@ideal-rain-33