--- id: anysqlite version: "0.0.5" license: unclear license_treatment: unclear maintenance: aging --- # anysqlite License: unclear · Maintenance: aging · Downloads: 2.4M/mo ## 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 above — 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 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 - License: not declared (unclear) - Python support: supports_current - Install friction: low - Maintenance: aging - Downloads: 2.4M/month (top 5,000 on PyPI) - Known vulnerabilities: none known ## Tags async sqlite wrapper, sqlite asyncio trio, non-blocking sqlite queries, async database interface, sqlite async await, async-database, sqlite-wrapper [View on SkillFed](https://skillfed.io/packages/anysqlite) · [View on PyPI](https://pypi.org/project/anysqlite/)