anysqlite

What it is and what it does

Anysqlite provides an async/await wrapper around Python's standard sqlite3 library, allowing you to execute SQLite queries without blocking your async event loop. It abstracts over both asyncio and trio backends using anyio, so you can use the same code regardless of which async framework you've chosen.

The package is designed for developers building async applications that need local SQLite database access. It exposes familiar sqlite3 methods like connect(), execute(), and fetchone() but as coroutines, so they integrate naturally into async/await code. With only anyio as a runtime dependency and support for Python 3.8 through 3.12, it has minimal friction to install.

Use it for:

• Building async web applications that need local SQLite storage without blocking the event loop
• Writing async CLI tools or daemons that query a local SQLite database
• Testing async code that requires database fixtures, using in-memory SQLite databases
• Migrating asyncio code to trio (or vice versa) while keeping the same database layer

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Anysqlite wraps SQLite with an async/await interface that works with both asyncio and trio, letting you query SQLite databases without blocking your async code.

Yes, if you need async SQLite access in a trio or asyncio project and can tolerate a package in beta with no recent releases. The low install friction, single lightweight dependency, and lack of known vulnerabilities make it safe to try. However, verify the license status before using in production or redistribution.

Install

anysqlite on PyPI

pip install anysqlite

uv add anysqlite

poetry add anysqlite

Installing anysqlite

Before you install

Installation is straightforward with no compiled dependencies. The package is in beta status and has not been updated since its initial release in October 2023, though the repository remains active.

License in practice

No license information is declared in the package metadata, making the legal status unclear for redistribution or commercial use.

Quickstart

pip install anysqlite

import anysqlite

conn = await anysqlite.connect(":memory:")
cursor = await conn.execute("SELECT DATETIME()")
response = await cursor.fetchone()

Requires Python 3.8 or later; must be called within an async context (asyncio or trio event loop)

Verify before relying

• Whether the package is actively maintained or in maintenance-only mode given the gap between latest release and recent repo activity
• What license applies to the code, given the absence of declared licensing in metadata

Package facts

Evidence: anysqlite-0.0.5-py3-none-any.whl

Tags

More Database packages