The engineering notebook
RSS feed#postgresql
Articles, practical guides, and engineering notes on postgresql.
By Ashish Bhakhand 108 published articles
Explore the articles
3 articles
Reset filtersDatabase Migrations Are Executable Architecture
Treat schema changes, constraints, backfills, compatibility, and cutovers as reviewed application design rather than deployment chores.
Who Owns the Transaction in a FastAPI Application?
Place transaction boundaries around complete business operations without pushing orchestration into routes or hiding it inside unrelated queries.
Direct SQL with asyncpg: Why I Do Not Add an ORM Automatically
Direct PostgreSQL access can make queries, constraints, and atomic behavior clearer when the team is willing to own the SQL.