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.15.2
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| motedb_python-0.15.2.tar.gz | 2.3 MB | With provenance | Details for motedb_python-0.15.2.tar.gz |
Built distributions (wheels)
| File | Actions Reset | |||
|---|---|---|---|---|
| motedb_python-0.15.2-cp39-abi3-win_amd64.whl | CPython 3.9 | abi3 | Windows x86-64 | Details for motedb_python-0.15.2-cp39-abi3-win_amd64.whl |
| motedb_python-0.15.2-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl | CPython 3.9 | abi3 | Linux glibc 2.17+ x86-64 | Details for motedb_python-0.15.2-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl |
| motedb_python-0.15.2-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl | CPython 3.9 | abi3 | Linux glibc 2.17+ ARM64 | Details for motedb_python-0.15.2-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl |
| motedb_python-0.15.2-cp39-abi3-macosx_11_0_arm64.whl | CPython 3.9 | abi3 | macOS 11.0+ ARM64 | Details for motedb_python-0.15.2-cp39-abi3-macosx_11_0_arm64.whl |
| motedb_python-0.15.2-cp39-abi3-macosx_10_12_x86_64.whl | CPython 3.9 | abi3 | macOS 10.12+ x86-64 | Details for motedb_python-0.15.2-cp39-abi3-macosx_10_12_x86_64.whl |
Total release size: 33.4 MB
Release files / motedb_python-0.15.2.tar.gz
| Download URL | motedb_python-0.15.2.tar.gz |
|---|---|
| Size | 2.3 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
7e4a43a96e71ff9bc0613c0eaa409d12c37815809ab7d6eaf9166ef2ea1a9b94
|
|
BLAKE2b-256 checksum How to use checksums |
dc1f0adbd4b162cbdddd5ea4e99e4376785e0e5e892181f498d457c223aa0e5c
|
| 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 Oct 22, 2026.
Transparency logRelease files / motedb_python-0.15.2-cp39-abi3-win_amd64.whl
| Download URL | motedb_python-0.15.2-cp39-abi3-win_amd64.whl |
|---|---|
| Size | 5.8 MB |
| Tags | CPython 3.9 Windows x86-64 abi3 |
|
SHA-256 checksum How to use checksums |
921094df9cb117e4a0c87cdf9541b61f20deb38fc8768cecbaff7cd9d49e6bff
|
|
BLAKE2b-256 checksum How to use checksums |
8a2098cff1807c2a007da4c9ce8042f8a700285f7274d89695a7ae21b04be1e5
|
| 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 Oct 22, 2026.
Transparency logRelease files / motedb_python-0.15.2-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
| Download URL | motedb_python-0.15.2-cp39-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl |
|---|---|
| Size | 6.6 MB |
| Tags | CPython 3.9 Linux glibc 2.17+ x86-64 abi3 |
|
SHA-256 checksum How to use checksums |
eedbef1e04327b97ce422a3592f60e58dce2fc150822d346ddf48011e5042937
|
|
BLAKE2b-256 checksum How to use checksums |
50cccb3b79fe95498151e1a2ad097c981c9a9b18c663467d78ef77f4d5964578
|
| 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 Oct 22, 2026.
Transparency logRelease files / motedb_python-0.15.2-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
| Download URL | motedb_python-0.15.2-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl |
|---|---|
| Size | 6.5 MB |
| Tags | CPython 3.9 Linux glibc 2.17+ ARM64 abi3 |
|
SHA-256 checksum How to use checksums |
d209420f649940d17bc4956365b0f3d3accbfc555d5436dfbcb2b0227ec98141
|
|
BLAKE2b-256 checksum How to use checksums |
5ec8c658caef07eed6c019ef2dfec05aa1f61ddea9893a3a2fb343ac18e0f01a
|
| 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 Oct 22, 2026.
Transparency logRelease files / motedb_python-0.15.2-cp39-abi3-macosx_11_0_arm64.whl
| Download URL | motedb_python-0.15.2-cp39-abi3-macosx_11_0_arm64.whl |
|---|---|
| Size | 5.9 MB |
| Tags | CPython 3.9 abi3 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
4fde22643d4d816dba7c0b661d2f5158418f2947cf1cf664c038a0fc22d0d48a
|
|
BLAKE2b-256 checksum How to use checksums |
b195a8cc18b1b39c3b6ea807d4f0b8f2888c3c372a11c590a8a2364d46c158a6
|
| 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 Oct 22, 2026.
Transparency logRelease files / motedb_python-0.15.2-cp39-abi3-macosx_10_12_x86_64.whl
| Download URL | motedb_python-0.15.2-cp39-abi3-macosx_10_12_x86_64.whl |
|---|---|
| Size | 6.3 MB |
| Tags | CPython 3.9 abi3 macOS 10.12+ x86-64 |
|
SHA-256 checksum How to use checksums |
2ecfd100fbc523be25b33316000f44546f5712ddb32d97168898a3a8c6106824
|
|
BLAKE2b-256 checksum How to use checksums |
371687baac326c0093fbefbfcb54b47b772399d5bdf0ab2e05ddbd9e2c049855
|
| 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 Oct 22, 2026.
Transparency logSecurity for motedb-python 0.15.2
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.
Attestation for motedb_python-0.15.2.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 Oct 22, 2026.
Transparency logA 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.