transactions

I have concurrent reads and writes and am seeing unexpected behavior: dirty reads, non-repeatable reads, or phantom rows. I need to understand PostgreSQL isolation levels and when to use each.

FastAPI database dependency using SQLAlchemy async session. Need automatic transaction rollback when route handlers raise exceptions, and ensure sessions are always closed without leaking connections....