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.18.3

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.18.3
File Size Uploaded Provenance Actions
motedb_python-0.18.3.tar.gz 2.7 MB With provenance Details for motedb_python-0.18.3.tar.gz

Built distributions (wheels)

Table of built distributions (wheels) for motedb-python 0.18.3
File Actions
motedb_python-0.18.3-cp39-abi3-win_amd64.whl CPython 3.9 abi3 Windows x86-64 Details for motedb_python-0.18.3-cp39-abi3-win_amd64.whl
motedb_python-0.18.3-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.18.3-cp39-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
motedb_python-0.18.3-cp39-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl CPython 3.9 abi3 Linux glibc 2.17+ ARM64 Details for motedb_python-0.18.3-cp39-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl
motedb_python-0.18.3-cp39-abi3-macosx_11_0_arm64.whl CPython 3.9 abi3 macOS 11.0+ ARM64 Details for motedb_python-0.18.3-cp39-abi3-macosx_11_0_arm64.whl
motedb_python-0.18.3-cp39-abi3-macosx_10_12_x86_64.whl CPython 3.9 abi3 macOS 10.12+ x86-64 Details for motedb_python-0.18.3-cp39-abi3-macosx_10_12_x86_64.whl

Total release size: 51.0 MB

Release files / motedb_python-0.18.3.tar.gz

Download URL motedb_python-0.18.3.tar.gz
Size 2.7 MB
Tags Source
SHA-256 checksum
How to use checksums
5bbe1827cd6ef0eff646b28e7e9a19713e1c2ad6c318c1bbedc620e646a3a258
BLAKE2b-256 checksum
How to use checksums
c0463657af622084c091377bdfedb450c6a395fe2005e77bcb2355b1cc9bc965
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 9, 2026.

Transparency log

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

Download URL motedb_python-0.18.3-cp39-abi3-win_amd64.whl
Size 9.1 MB
Tags CPython 3.9 Windows x86-64 abi3
SHA-256 checksum
How to use checksums
b08cc78b18f80d733ec8171851b52eb2f87da17600320906110f5c9fe3250c61
BLAKE2b-256 checksum
How to use checksums
55751b1a441c52971274c1a8d208140039e7adc493ca822a60a236114970ca16
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 9, 2026.

Transparency log

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

Download URL motedb_python-0.18.3-cp39-abi3-manylinux2014_x86_64.manylinux_2_17_x86_64.whl
Size 10.1 MB
Tags CPython 3.9 Linux glibc 2.17+ x86-64 abi3
SHA-256 checksum
How to use checksums
7eda8f4d4aad975d2f0196fb462a367201fdd00522588dda3c8762c4eaee76df
BLAKE2b-256 checksum
How to use checksums
c31c52f8ad3de560d4ce85c4ea4412a9c755742be5ed4e440b4dc893a3cabb7c
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 9, 2026.

Transparency log

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

Download URL motedb_python-0.18.3-cp39-abi3-manylinux2014_aarch64.manylinux_2_17_aarch64.whl
Size 10.2 MB
Tags CPython 3.9 Linux glibc 2.17+ ARM64 abi3
SHA-256 checksum
How to use checksums
dd967a055eeb4be7e5e24a528ea790514f3dc693db186de074f55682e0d5779b
BLAKE2b-256 checksum
How to use checksums
5d74e7dc10eb5d8ba95c416ad14b175744cf3be918f27f0501065ad02a64ed44
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 9, 2026.

Transparency log

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

Download URL motedb_python-0.18.3-cp39-abi3-macosx_11_0_arm64.whl
Size 9.3 MB
Tags CPython 3.9 abi3 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
8779fce63f4edb21eafc24a4ad2508c461629e6ef1929057f2a6181bcdf3784d
BLAKE2b-256 checksum
How to use checksums
7e1e14708d1008f68dfe18858da0b3ff06826f083d8a953248a07af3b7ea5e1f
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 9, 2026.

Transparency log

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

Download URL motedb_python-0.18.3-cp39-abi3-macosx_10_12_x86_64.whl
Size 9.7 MB
Tags CPython 3.9 abi3 macOS 10.12+ x86-64
SHA-256 checksum
How to use checksums
cf80d83457a5f9e5e18327b85b4a60e38fbb842add5ff6ac54c981541aefd0e4
BLAKE2b-256 checksum
How to use checksums
017a779842c82570f5505275f6dcdecb7a524b1e39d82fbf0c61368d789c56e5
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 9, 2026.

Transparency log

Security for motedb-python 0.18.3

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.18.3.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 9, 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