SQLAlchemy Relationship Loading: Joined, Selectin, or Raise
Stop N+1 queries by choosing the right SQLAlchemy eager-loading strategy for each relationship shape.
Loading…
ReadMeFeed / Community knowledge
Sqlalchemy
Real questions. Useful conversations. Find the people who know your stack.
Sqlalchemy
Developer tools · #sqlalchemy
Choosing a Database Integration Strategy for Flask: Flask-SQLAlchemy vs. Raw SQLAlchemy
Deciding between Flask-SQLAlchemy and raw SQLAlchemy depends on whether you prioritize rapid development or architectural decoupling. This guide compares session management, async support, and migration workflows.
SQLAlchemy Declarative Mixin for Database-Managed created_at and updated_at
Use a reusable SQLAlchemy declarative mixin with server_default=func.now() and onupdate=func.now() to let the database manage created_at and updated_at without application code.
Architecting a Single-Writer Web Service with SQLAlchemy 2.0
A technical guide on implementing SQLAlchemy 2.0 in a single-writer web service, focusing on the unit-of-work pattern, connection pooling, and avoiding common ORM pitfalls like N+1 queries.
pythonManaging Request State with FastAPI Dependency Injection
Learn how to use FastAPI's Dependency Injection system to manage database sessions and request state without leaking resources or duplicating code.
fastapiChoosing Between joinedload and selectinload in SQLAlchemy 2.0
Avoid N+1 queries in SQLAlchemy by choosing selectinload for collections and joinedload for scalar relationships, then verify with echo=True.
Using FastAPI Dependency Injection for Safe Resource Management
Learn how FastAPI's Depends and yield patterns eliminate duplicated setup code and guarantee cleanup of database sessions, auth tokens, and other shared resources.
Diagnosing SQLAlchemy Connection Pool Exhaustion: A Production Guide
A step-by-step diagnostic guide for SQLAlchemy QueuePool exhaustion: recognize the symptoms, trace held connections, and apply staged fixes without overwhelming your database.
Using SQLAlchemy joinedload to Stop N+1 Queries on Many-to-One Relations
Learn how SQLAlchemy's joinedload replaces N+1 queries with a single JOIN for many-to-one and one-to-one relations, when to use it, and what to watch out for.