SMBDB

SMBDB is an early-stage embedded relational database engine designed for safe, selective access to databases stored on SMB shares. This repository currently contains the project foundation, local and direct SMB storage backends, a versioned database format, immutable column segments, pruning, and adaptive block compression, an initial SQL frontend, and immutable primary-key indexes.

Requires Python 3.11 or newer. See docs/architecture.md and docs/storage-format.md for the current design.

import smbdb

db = smbdb.create("/tmp/company.smbdb")
db.close()

db = smbdb.connect("/tmp/company.smbdb")
print(db.info())
db.close()

The same SQL API works with a local path or an smb:// URL:

db = smbdb.create("/tmp/company.smbdb")
db.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT NOT NULL)")
db.execute("INSERT INTO users (id, name) VALUES (?, ?)", [1, "Adam"])
print(db.execute("SELECT name FROM users WHERE id = ?", [1]).fetchall())
db.close()

Direct SMB does not require a mount or a server-side SMBDB process:

db = smbdb.create(
    "smb://fileserver/share/company.smbdb",
    username="user",
    password="secret",
)
db.close()

Development checks:

python3 -m venv .venv
.venv/bin/python -m pip install -e '.[dev]'
.venv/bin/python -m pytest
.venv/bin/ruff check .
.venv/bin/mypy src/smbdb