aiosqlite

Aiosqlite provides an asyncio bridge for SQLite by running blocking database operations in a dedicated thread pool.

Aiosqlite enables non-blocking SQL operations in Python 3.7+ applications by wrapping the standard sqlite3 module. It utilizes a background thread to execute queries, allowing the main event loop to handle concurrent tasks without stalling. Developers use familiar async/await syntax to manage connections and cursors (e.g., await db.execute("SELECT 1")). This library is a critical dependency for high-performance projects like the Home Assistant automation engine and the Chia blockchain.

https://github.com/omnilib/aiosqlite