fastapi-nplusone 0.0.1b2

A middlewere to help find n+1 queries in sqlalchemy.

FastAPI / SQLAlchemy N+1 query middleware

A FastAPI middleware to find N+1 queries in development. This middleware helps developers identify and fix N+1 query issues in their FastAPI applications. It provides logging information on the query and the number of N+1 query occurrences. This is helpful in identifying and fixing N+1 query issues.

This middleware should probably not be used in production, but it can be useful in development.

Installation

Pip Install:

pip install fastapi-nplusone

UV install:

uv install fastapi-nplusone

Poetry install:

poetry add fastapi-nplusone

Usage

You probably want to disable this middleware in production.

from fastapi import FastAPI
from fastapi_nplusone import NPlusOne

app = FastAPI()
if not app.debug:
    app.add_middleware(NPlusOne)

Tests

To run the tests:

uv run pytest ./tests