rapsqlite 0.0.1

True async SQLite — no fake async, no GIL stalls.

rapsqlite

True async SQLite — no fake async, no GIL stalls.

---

Why rap*?

Packages prefixed with rap stand for Real Async Python. Unlike many libraries that merely wrap blocking I/O in async syntax, rap* packages guarantee that all I/O work is executed outside the Python GIL using native runtimes (primarily Rust). This means event loops are never stalled by hidden thread pools, blocking syscalls, or cooperative yielding tricks. If a rap* API is async, it is structurally non-blocking by design, not by convention. The rap prefix is a contract: measurable concurrency, real parallelism, and verifiable async behavior under load.

See the rap-manifesto for philosophy and guarantees.

---

What this package provides

• True async SQLite operations
• Native Rust-backed execution (Tokio)
• Zero Python thread pools
• Event-loop-safe concurrency under load
• GIL-independent database operations
• Async-safe SQLite bindings

---

Installation

pip install rapsqlite

---

Usage

import asyncio
from rapsqlite import Connection

# TODO: Implement async API
# async def main():
#     conn = await Connection.create("example.db")
#     await conn.execute("CREATE TABLE test (id INTEGER PRIMARY KEY)")
#     await conn.execute("INSERT INTO test VALUES (1)")

# asyncio.run(main())

---

Benchmarks

This package passes the Fake Async Detector. Benchmarks are available in the rap-bench repository.

---

Non-Goals

• Not a drop-in replacement for sqlite3 or aiosqlite
• Not compatible with all SQLite features (yet)
• Not designed for synchronous use cases

---

License

MIT