Tags

3 pages

Sqlalchemy

3 pages

Technology Web Development

Litestar DTOs: The 'Advanced Feature' I Didn't Need (And When You Might)

I thought I was doing it wrong by not using DTOs. Turns out, sometimes the simple approach is exactly right—here's how to know which to choose

Databases Python FastAPI

Wait, Even SELECT Starts a Transaction?—A Curious Tour of DB Locks, MVCC, and SQLAlchemy's 'Magic' Sessions

A 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 SQLAlchemy

Async SQLAlchemy Journey: From Confusion to Clarity

Exploring the pitfalls and revelations of migrating from synchronous to async SQLAlchemy with FastAPI