encode/databases

Health v2 · maintenance only

Flags: archived

Adoption not part of the score

3994 stars · 264 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

A Python library providing simple asyncio support for PostgreSQL, MySQL, and SQLite databases, with query building via the SQLAlchemy Core expression language. It is designed to integrate with async web frameworks like Starlette, FastAPI, Sanic, and aiohttp.

Use cases

• run async database queries in Python with asyncio
• use SQLAlchemy Core queries with async drivers
• connect to PostgreSQL, MySQL, or SQLite from FastAPI or Starlette
• execute parameterized queries and bulk inserts asynchronously
• swap between asyncpg, aiomysql, and aiosqlite drivers behind one interface

When to choose

• you need async database access in an asyncio-based web app
• you want SQLAlchemy Core query building without a full ORM
• you want a uniform async API across Postgres, MySQL, and SQLite

When to avoid

• you need a full ORM with relationships and unit-of-work (use SQLAlchemy 2.0 async instead)
• you need databases beyond PostgreSQL, MySQL, or SQLite
• you need a synchronous database layer

Facets

library · maturity maintenance

database database-driver orm databases backend web-development developer-tools python cross-platform asyncio sqlalchemy-core asyncpg aiosqlite aiomysql asyncmy aiopg postgresql mysql sqlite async-web-frameworks

Member repositories

For agents

markdown · JSON · MCP: product_card(name="encode/databases")