ORM (encode/orm)

About ORM (encode/orm)

Lightweight and async-ready ORM designed to work with FastAPI and Starlette. Particularly suited for applications requiring asynchronous database operations with minimal overhead and modern Python async/await patterns.

Key Features

• 1Async ORM built on SQLAlchemy Core for use with Starlette and FastAPI
• 2Supports PostgreSQL (asyncpg), MySQL (aiomysql), and SQLite (aiosqlite)
• 3Simple Model class with async `all()`, `get()`, `create()`, and `filter()` methods
• 4Integrates with Alembic for schema migrations
• 5Lightweight — minimal abstraction over raw SQL for predictable behavior

How Python Data Engineers Use ORM (encode/orm)

Python data engineers building async data APIs with FastAPI or Starlette use the `databases` (Encode ORM) library to perform non-blocking database operations. It replaces synchronous `psycopg2` calls with awaitable async queries, keeping the event loop unblocked during database I/O in high-concurrency ingestion endpoints.