{"library":"sqlite-anyio","title":"Asynchronous SQLite client with AnyIO","type":"library","description":"sqlite-anyio is an asynchronous client for SQLite databases, built on top of the AnyIO library. It provides an `async`/`await` interface for interacting with SQLite, enabling non-blocking database operations within asynchronous Python applications. The current version is 0.2.8, and it maintains a frequent release cadence, often introducing minor features or bug fixes.","language":"python","status":"active","last_verified":"Mon May 18","install":{"commands":["pip install sqlite-anyio"],"cli":null},"imports":["from sqlite_anyio import Connection"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/davidbrochart/sqlite-anyio","docs":null,"changelog":null,"pypi":"https://pypi.org/project/sqlite-anyio/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import anyio\nfrom sqlite_anyio import Connection\nimport os\n\nasync def main():\n    db_path = \"test.db\"\n    async with Connection(db_path) as conn:\n        await conn.execute(\"CREATE TABLE IF NOT EXISTS users (id INTEGER, name TEXT)\")\n        await conn.execute(\"INSERT INTO users VALUES (?, ?)\", 1, \"Alice\")\n        await conn.execute(\"INSERT INTO users VALUES (?, ?)\", 2, \"Bob\")\n\n        async with conn.cursor() as cur:\n            await cur.execute(\"SELECT id, name FROM users\")\n            rows = await cur.fetchall()\n            print(f\"All users: {rows}\")\n\n            await cur.execute(\"SELECT id, name FROM users WHERE id = ?\", 1)\n            row = await cur.fetchone()\n            print(f\"User with ID 1: {row}\")\n\n    # Clean up the database file\n    if os.path.exists(db_path):\n        os.remove(db_path)\n\nif __name__ == \"__main__\":\n    anyio.run(main)","lang":"python","description":"This quickstart demonstrates opening an asynchronous connection to an SQLite database, creating a table, inserting data, and querying it using both `Connection.execute` and `Cursor` objects, all within an AnyIO runtime. It also shows proper resource management using async context managers.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":{"tag":null,"tag_description":null,"last_tested":"2026-05-18","installed_version":"0.2.3","pypi_latest":"0.2.8","is_stale":true,"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":1.9,"avg_import_s":0.29,"wheel_type":"wheel"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.23,"mem_mb":8.1,"disk_size":"20.1M"},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":1.9,"import_time_s":0.18,"mem_mb":8.1,"disk_size":"21M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.33,"mem_mb":9.2,"disk_size":"22.0M"},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":1.9,"import_time_s":0.29,"mem_mb":9.2,"disk_size":"23M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.51,"mem_mb":12.1,"disk_size":"13.8M"},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":1.8,"import_time_s":0.5,"mem_mb":12.1,"disk_size":"14M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.26,"mem_mb":7.8,"disk_size":"13.6M"},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":1.8,"import_time_s":0.26,"mem_mb":7.8,"disk_size":"14M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.17,"mem_mb":6.5,"disk_size":"19.4M"},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"sqlite-anyio","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":2.2,"import_time_s":0.15,"mem_mb":6.5,"disk_size":"20M"}]}}