AAsfaq Leeon1d ago · 28 min readBuilding a Production-Style CRUD API with FastAPI, SQLAlchemy 2.0 and PostgreSQLFrom an empty folder to a Dockerized API, written for developers who already know how to program but are new to the Python/FastAPI world. If you've built REST APIs in Java, C#, Node.js or Go, you alrleeonscoding.hashnode.dev
PParsa MohammadiOct 21 · 5 min readA Blind Scan Found IBM ContextForge's Connection Leak From One FileOn January 3, 2026, a 3,000-user load test against IBM ContextForge left PostgreSQL connections stuck in idle in transaction until the pool ran dry. The cause was three lines of cleanup code. We rewoutomosu.hashnode.dev
MMadhav BhasinSep 1 · 6 min readPostgreSQL Connection Pooling on Cloud Run: The Problem Nobody Warns You AboutCloud Run scales horizontally. That's the point. Under load, it spins up new instances automatically — each one handling concurrent requests, each one maintaining its own connection pool to your Cloud3blog.madhav.dev
AAseem AggawralJul 28 · 9 min read03 - Database Migrations with Alembic in a FastAPI Project📌 GitHub Repository: AI Engineer Foundation After setting up the FastAPI project structure, the next backend concept I wanted to understand was database migration. At the beginning, it is tempting toaseemtech.hashnode.dev
SSahil KhuranaJun 15 · 8 min readSQLAlchemy Essentials: A Beginner's RoadmapKey Takeaways SQLAlchemy is both an ORM and a SQL toolkit — pick one, use both, whatever works for your situation. Learn Engine, Session, and Declarative Base first. Seriously, before you write anytinnostaxengineering.hashnode.dev
SScopieApr 29 · 5 min readWhy My PostgreSQL Tables Weren't Being Created — And How AUTOCOMMIT Fixed ItThe Setup I was building a FastAPI backend with async SQLAlchemy, asyncpg, and Alembic for database migrations. The stack was clean — PostgreSQL as the database, pydantic-settings for environment manascopie.hashnode.dev
KKevin - Backend, System Design, AutomationMar 22 · 6 min readUsing Async SQLAlchemy Inside Sync Celery TasksIntroduction Let me be honest. I've built this beautiful, modern web application using FastAPI and Async SQLAlchemy. Everything is blazing fast and non-blocking. Then, I needed to handle background jo1backendprep.hashnode.dev
Wwajahat tajFeb 14 · 3 min readFAST API connecting to Data Base Using SQLAlchemy ORMfrom collections.abc import AsyncGenerator import uuid # UUID = Universally Unique Identifier. from sqlalchemy import Column , String , Text , DateTime , ForeignKey from sqlalchemy.dialects.postgresql import UUID from sqlalchemy.ext.asyncio impo...fast-api-blog.hashnode.dev
AAyush KaushikJan 30 · 4 min readFixing “QueuePool limit reached”: Debugging DB Connection Leaks in FastAPIThe Nightmare Scenario Your FastAPI app runs perfectly on your local machine. You deploy it to production. It works fine for a few hours. Then, suddenly, requests start hanging. Your logs are flooded with this error: Plaintext sqlalchemy.exc.TimeoutE...logiclooptech.dev
AAyush KaushikJan 21 · 3 min readAsyncSession Has No Attribute query in SQLAlchemy 2.0 (FastAPI Fix)If you recently upgraded to SQLAlchemy 2.0 and suddenly saw AttributeError: 'AsyncSession' object has no attribute 'query', nothing is actually broken. This error appears because SQLAlchemy 2.0 removed legacy query patterns entirely and async session...logiclooptech.dev
