omnilib/aiosqlite

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

1568 stars · 107 forks observed · 2026-08-28

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

aiosqlite is a Python library providing an asyncio-friendly interface to SQLite databases, replicating the standard sqlite3 module with async versions of connection and cursor methods. It runs database operations on a dedicated thread per connection so queries don't block the event loop.

Use cases

• use sqlite in an asyncio application without blocking the event loop
• run async SQL queries from FastAPI or aiohttp handlers
• async iterate over sqlite query results
• manage sqlite connections with async context managers
• migrate sync sqlite3 code to async python

When to choose

• you need SQLite access inside an asyncio event loop
• you want a drop-in async mirror of the sqlite3 API
• you need lightweight embedded storage in async Python code

When to avoid

• you need a network database server like PostgreSQL or MySQL
• your application is synchronous and doesn't use asyncio
• you need high-concurrency writes, since SQLite is single-writer

Facets

library · maturity stable

database-driver database concurrency databases developer-tools backend python cross-platform asyncio sqlite async-database non-blocking-io

Member repositories

For agents

markdown · JSON · MCP: product_card(name="omnilib/aiosqlite")