Feb 14 · 3 min read · from 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...
Join discussion
Jan 30 · 4 min read · The 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...
Join discussion
Jan 21 · 3 min read · 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...
Join discussion
Jan 19 · 3 min read · 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...
Join discussion
Jan 15 · 5 min read · 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 ...
Join discussion
Dec 20, 2025 · 2 min read · ProblemI 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...
Join discussionDec 11, 2025 · 7 min read · Django 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...
Join discussionDec 6, 2025 · 10 min read · I am building an API because I don’t have time or the energy to build out a full application for my crew. Before I jumped off the deep end on building a Flask API, I first did the blog tutorial found in the documentation. The reasoning was to get use...
Join discussion
Nov 2, 2025 · 9 min read · Your FastAPI app is humming in dev. Endpoints respond in under 50ms, tests pass, the team is happy. You ship to prod. Traffic climbs past 80 concurrent users and suddenly... your database pool is exhausted, requests are hanging, and your monitoring s...
Join discussion
Sep 30, 2025 · 16 min read · ORM 을 사용하다보면 어떤 방법으로 연관된 엔티티들을 조회할 방식에 대해 고민을 많이 하게된다. Python 을 사용하면 주로 SQLAlchemy 를 주 ORM 으로 많이 사용하게 되는데, SQLAlchemy 에는 크게 3가지 정도의 연관관계 로딩 방법이 존재한다. 오늘은 그 중 selectinload , joinedload , subqueryload 에 대해서 알아보려고 한다. 모델링 일단 테스트를 위한 엔티티 생성은 아래와 같이 조금 복잡...
Join discussion