SKSahil Khuranaininnostaxengineering.hashnode.dev·Jun 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 anyt00
SScopieinscopie.hashnode.dev·Apr 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 mana00
K-Kevin - Backend, System Design, Automationinbackendprep.hashnode.dev·Mar 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 jo10
WTwajahat tajinfast-api-blog.hashnode.dev·Feb 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...00
AKAyush Kaushikinlogiclooptech.dev·Jan 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...00
AKAyush Kaushikinlogiclooptech.dev·Jan 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...00
AKAyush Kaushikinlogiclooptech.dev·Jan 19 · 3 min readFixing SQLAlchemy MissingGreenlet Error in FastAPI (Async Explained)Introduction If you’re using FastAPI with SQLAlchemy 2.0 async and suddenly hit a MissingGreenlet error, you’re not alone. This error usually appears when async database calls are executed outside the proper event loop context -often due to incorrect...00
AKAyush Kaushikinlogiclooptech.dev·Jan 15 · 5 min readFix AsyncSession Errors in FastAPI (SQLAlchemy 2.0 Guide)Introduction Building async APIs with FastAPI and SQLAlchemy 2.0 looks straightforward in tutorials, until you deploy to production. Suddenly you start seeing issues like random MissingGreenlet errors, confusing async session behavior, blocked event ...00
POPrecious Obinnainprecious-o.hashnode.dev·Dec 20, 2025 · 2 min readThe Hidden Cost of Reusing Database Sessions in Backend ApplicationsProblemI was working on a project recently, A backend endpoint consistently returned stale data even after updates were successfully written to the database. Restarting the server immediately fixed the issue and caused the endpoint to return the corr...00
OOnchanainunderstandpython.hashnode.dev·Dec 11, 2025 · 7 min readBridging Django and SQLAlchemy: Using Aldjemy to Generate Foreign Keys from Django’s ForeignKey FieldsDjango is widely known for its powerful and intuitive ORM (Object-Relational Mapper), which simplifies database interactions using Pythonic syntax. However, there are scenarios—such as complex query requirements, advanced SQL operations, or integrati...00
