Skip to main content

MoteDB Python Bindings

Embedded multimodal database for Python — SQL + vector search + full-text search + spatial in one engine, with edge-presets for memory-constrained devices.

Install (from source)

pip install maturin
cd bindings/python
maturin develop --release
# no maturin / offline? scripts/build_wheel.sh builds a wheel with cargo+zip

Quick start

import motedb

db = motedb.Database("/data/store.mote", preset="edge")   # general|edge|robotics|embodied
db.execute("CREATE TABLE IF NOT EXISTS docs (id INT PRIMARY KEY AUTO_INCREMENT, text TEXT, emb VECTOR(384))")
db.execute("INSERT INTO docs (text, emb) VALUES (?, ?)", params=["hello world", [0.1] * 384])

rows = db.execute("SELECT id, text FROM docs WHERE text MATCH AGAINST('hello')")   # list[dict]
cols, tuples = db.query("SELECT id, text FROM docs")                               # (columns, list[tuple])

# Vector ANN — literal or parameter vectors both order correctly:
near = db.execute("SELECT id FROM docs ORDER BY emb <-> ? LIMIT 5", params=[[0.1] * 384])

tx = db.begin()
db.execute("UPDATE docs SET text = ? WHERE id = 1", params=["hi"])
db.rollback(tx)          # or db.commit(tx)

db.checkpoint()          # durability point
db.close()

API

Method Notes
Database(path, preset=None, create=True) create-or-open
execute(sql, params=None) SELECT → list[dict]; DML → affected count; DDL → None
query(sql, params=None) SELECT → (columns, list[tuple])
executemany(sql, params) one INSERT per parameter set — single WAL fsync per batch
begin()/commit(tx)/rollback(tx) transactions
doctor() self-check → {"verdict", "checks": [{name,status,detail}]}
checkpoint()/vacuum()/close() lifecycle

Parameter types: None/bool/int/float/str/list[float] (→ embedding vector), and geometry dicts for GEOMETRY columns: {"type": "Point3D", "x": 1.0, "y": -2.0, "z": 0.5}, {"type": "Point", "x": 1.0, "y": -2.0}, {"type": "LineString"|"Polygon", "points": [[x, y], ...]}. Result types: None/bool/int/float/str/list[float] (vector), timestamp as int microseconds, geometry as the same dict shapes (tensor still renders as a <tensor> tag).

Benchmark

bench/bench_edge.py — reproducible edge-workload comparison vs stdlib SQLite (see bench/README.md for methodology and reference numbers: point 2.9×, filter 3.7×, GROUP BY 9.8×, ANN 3.2×, RSS −12%; honest loss on batch insert).

Publishing

Wheels for 4 targets are built by .github/workflows/python-wheels.yml on tag push; PyPI publishing uses Trusted Publisher (register the repo at pypi.org → no token secret needed).

Known gaps (pre-1.0)

  • Tensor/Spatial/TextDoc values pass through as tags, not Python objects.

Metadata

Release files for motedb-python 0.17.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for motedb-python 0.17.0
File Size Uploaded Provenance Actions
motedb_python-0.17.0.tar.gz 2.6 MB With provenance Details for motedb_python-0.17.0.tar.gz

Built distributions (wheels)

Table of built distributions (wheels) for motedb-python 0.17.0
File Actions
motedb_python-0.17.0-cp39-abi3-win_amd64.whl CPython 3.9 abi3 Windows x86-64 Details for motedb_python-0.17.0-cp39-abi3-win_amd64.whl
motedb_python-0.17.0-cp39-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl CPython 3.9 abi3 Linux glibc 2.17+ x86-64 Details for motedb_python-0.17.0-cp39-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
motedb_python-0.17.0-cp39-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl CPython 3.9 abi3 Linux glibc 2.17+ ARM64 Details for motedb_python-0.17.0-cp39-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl
motedb_python-0.17.0-cp39-abi3-macosx_11_0_arm64.whl CPython 3.9 abi3 macOS 11.0+ ARM64 Details for motedb_python-0.17.0-cp39-abi3-macosx_11_0_arm64.whl
motedb_python-0.17.0-cp39-abi3-macosx_10_12_x86_64.whl CPython 3.9 abi3 macOS 10.12+ x86-64 Details for motedb_python-0.17.0-cp39-abi3-macosx_10_12_x86_64.whl

Total release size: 49.7 MB

Release files / motedb_python-0.17.0.tar.gz

Download URL motedb_python-0.17.0.tar.gz
Size 2.6 MB
Tags Source
SHA-256 checksum
How to use checksums
4601b65989f5b71276f10e8ff5893cc58aaef19f99be9c185e7b39796be4295e
BLAKE2b-256 checksum
How to use checksums
b0735fced39045e7fb09f6a8266a346e47a0700e0dda8872e697db3c5692fb9e
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 3, 2026.

Transparency log

Release files / motedb_python-0.17.0-cp39-abi3-win_amd64.whl

Download URL motedb_python-0.17.0-cp39-abi3-win_amd64.whl
Size 8.9 MB
Tags CPython 3.9 Windows x86-64 abi3
SHA-256 checksum
How to use checksums
9699ad6c033081845ad9c733683ed3e0293bce491310e126201bc20d03a3a403
BLAKE2b-256 checksum
How to use checksums
0adc66320cb8ab15d855c457a1bd416109a34cf888137bf9a881f87df2afbd4f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 3, 2026.

Transparency log

Release files / motedb_python-0.17.0-cp39-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl

Download URL motedb_python-0.17.0-cp39-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Size 9.8 MB
Tags CPython 3.9 Linux glibc 2.17+ x86-64 abi3
SHA-256 checksum
How to use checksums
6075a084526d16e0ef6c4c85eea053437bce8457c16c94dd7697afd51a119207
BLAKE2b-256 checksum
How to use checksums
b8ea42214e0792ddbc3cd6043e2c17b51e9ff76c348adafa12249e4d2235ab19
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 3, 2026.

Transparency log

Release files / motedb_python-0.17.0-cp39-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl

Download URL motedb_python-0.17.0-cp39-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl
Size 9.9 MB
Tags CPython 3.9 Linux glibc 2.17+ ARM64 abi3
SHA-256 checksum
How to use checksums
b7cbe99fef85c5911b477442629ae81f7f8ffb70622c7de96b2ed576024b1e0d
BLAKE2b-256 checksum
How to use checksums
270276e4081ba9123e63f0c27b7ef9a550ec704df251c1e88982ae85daa0d64b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 3, 2026.

Transparency log

Release files / motedb_python-0.17.0-cp39-abi3-macosx_11_0_arm64.whl

Download URL motedb_python-0.17.0-cp39-abi3-macosx_11_0_arm64.whl
Size 9.1 MB
Tags CPython 3.9 abi3 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
bb303681a0b744e6d278926f58389462213cc385856337bb3a7e8f75a1fb006c
BLAKE2b-256 checksum
How to use checksums
19dcfd3f265d84a99c44e993fcd2a2193534dcc7fb0cc6b97c5fa0c251c9343a
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 3, 2026.

Transparency log

Release files / motedb_python-0.17.0-cp39-abi3-macosx_10_12_x86_64.whl

Download URL motedb_python-0.17.0-cp39-abi3-macosx_10_12_x86_64.whl
Size 9.4 MB
Tags CPython 3.9 abi3 macOS 10.12+ x86-64
SHA-256 checksum
How to use checksums
eb5cbc85f290f3c9e4abdc0d33930373114acf02e8a2e78c56aea64cc557de8d
BLAKE2b-256 checksum
How to use checksums
c85e1f7fa0af67554864002c53f5ec23baaad4d0d1f909356e45f7903667086b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 3, 2026.

Transparency log

Security for motedb-python 0.17.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Full provenance

All 6 files in this release have been uploaded with provenance metadata.

Select from 6 files

Attestation for motedb_python-0.17.0.tar.gz

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 3, 2026.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page