Databases Python FastAPIWait, Even SELECT Starts a Transaction?—A Curious Tour of DB Locks, MVCC, and SQLAlchemy's 'Magic' SessionsA step‑by‑step journey from 'I have no idea what a transaction really does' to 'I can reason about row‑level locks and auto‑begin like a pro,' using simple code, real‑life analogies, and plenty of aha‑moments.
Python FastAPI SQLAlchemyAsync SQLAlchemy Journey: From Confusion to ClarityExploring the pitfalls and revelations of migrating from synchronous to async SQLAlchemy with FastAPI