sqlxtralite 0.1.0

Python (DB-API 2.0) binding for SQLXtraLite — a from-scratch SQL engine in Rust

SQLXtraLite — Python binding (PyO3, DB-API 2.0)

A native CPython extension built with PyO3 that calls the Rust engine directly (no C-ABI round-trip) and exposes a small DB-API 2.0 surface. Values come back as native Python types (int, float, str, bytes, None).

There's also a zero-dependency ctypes binding in ../python/ — no build tools, but it returns string values. This PyO3 binding is the idiomatic, pip-installable one. The engine crate itself stays dependency-free; PyO3 lives only here.

Build & install

# from this directory (bindings/pyo3)
pip install maturin

maturin develop --release      # build + install into the current venv
# or build a redistributable wheel:
maturin build --release        # -> target/wheels/sqlxtralite-*.whl
pip install target/wheels/sqlxtralite-*.whl

A plain cargo build --release also links a loadable module here (via .cargo/config.toml); rename target/release/libsqlxtralite.dylib → sqlxtralite.so (.so on Linux) on your PYTHONPATH to import it without maturin.

Use

import sqlxtralite

con = sqlxtralite.connect("shop.db")
cur = con.cursor()
cur.execute("CREATE TABLE items (id INTEGER PRIMARY KEY, name TEXT, price REAL)")

cur.executemany("INSERT INTO items VALUES (?, ?, ?)",
                [(1, "basil", 2.95), (2, "mint", None)])

cur.execute("SELECT * FROM items WHERE price > ?", (1.0,))
print(cur.description)     # [('id', None, …), ('name', …), ('price', …)]
print(cur.fetchall())      # [(1, 'basil', 2.95)]   ← native int / str / float
print(cur.lastrowid, cur.rowcount)
con.close()

API (DB-API 2.0 subset)

Module: connect(path), apilevel = "2.0", threadsafety = 1, paramstyle = "qmark", Error.

Object	Methods / attrs
Connection	cursor(), execute(sql, params=None), commit(), rollback(), close(), context manager
Cursor	execute(sql, params=None), executemany(sql, seq), fetchone(), fetchmany(size=1), fetchall(), description, rowcount, lastrowid, close()

Parameters use qmark style (?), positional; None→NULL, int/float/str/ bytes bind directly. Prepared statements are used automatically when you pass params (and for executemany), giving the engine's fast bind path.

Run the test

maturin develop --release
python3 test_dbapi.py
# OK — PyO3 DB-API binding works

Notes

• Connection/Cursor are unsendable — use one connection per thread (the engine is single-writer; the GIL serializes calls anyway).
• SQLXtraLite auto-commits each statement, so commit()/rollback() are no-ops provided for DB-API shape; use explicit BEGIN/COMMIT SQL for multi-statement transactions.