sekejap for Python

An embedded, disk-first, multi-model database: documents addressed by collection and key, SQL with $n parameters over the same rows, typed edges between them, and vector and spatial fields in the one store.

This package is pure Python. It compiles nothing and it contains no Rust: it loads libsekejap — the shared library built from dist/ffi, whose contract is docs/dist/C_ABI.md — and calls its 59 entry points through ctypes. A platform wheel ships that library inside the package; an install from the source distribution finds one on the machine.

from sekejap import Db

with Db("./data") as db:
    db.create_collection("venues", [
        {"name": "name", "kind": "text"},
        {"name": "suburb", "kind": "text"},
        {"name": "capacity", "kind": "int"},
    ])
    db.put("venues", "the_tote", {"name": "The Tote", "suburb": "Collingwood"})

    for row in db.query("SELECT _key, name FROM venues WHERE suburb = $1",
                        ["Collingwood"]):
        print(row["_key"], row["name"])

Install

pip install sekejap

A wheel for your platform carries the library and needs nothing else. If you installed from the source distribution, or you want to run against a library you built yourself:

cargo build --release -p sekejap-capi          # in the sekejap repository
export SEKEJAP_LIBRARY=/path/to/libsekejap.dylib

SEKEJAP_LIBRARY is looked at first, then sekejap/_lib/ inside the package, then the platform loader path (DYLD_LIBRARY_PATH, LD_LIBRARY_PATH, PATH, and wherever make install in dist/ffi put it). sekejap.library_path() says which one this process loaded.

The handles

One class per opaque pointer in the C ABI. Each is a context manager, and closing a Db closes every handle taken from it first, because each of them borrows it.

class	from	what it is
`Db`	`Db(path)`, `Db.open_service(path)`	the database. May be shared across threads
`Statement`	`db.prepare(sql)`	one statement, parsed once, compiled at its first bind
`Scan`	`db.scan(collection)`, `db.stream(sql)`	a paged walk. Iterating yields documents; `.pages()` yields pages
`Tx`	`db.transaction()`	the writer, held across many writes under one barrier

Errors

A failure raises. The exception carries code, a Status enumeration member, so you branch on the code and never on the text of message.

from sekejap import Db, Refused, Status

try:
    db.compact()
except Refused as refusal:
    print(refusal.code is Status.REFUSED, refusal.message)

SekejapError is the base; Refused, Corrupt, Unsupported, IoFailure, Invalid, Busy and UnknownRow are the named ones. A miss is not a failure and does not raise: db.get and db.describe answer None, a walk answers None at its end, and db.next_change answers None when nothing arrived.

Every C function, and the call that reaches it

C function	Python
`sekejap_open`	`Db(path)` / `Db.open(path)`
`sekejap_open_with_config`	`Db(path, config={"budget_bytes": ..., "io": ..., "sync": ...})`
`sekejap_open_service`	`Db.open_service(path)` / `Db(path, service=True)`
`sekejap_close`	`db.close()`, or leaving a `with` block
`sekejap_version`	`sekejap.version()`
`sekejap_format_version`	`sekejap.format_version()`
`sekejap_last_error`	`sekejap.last_error()`, and `error.message` on every exception
`sekejap_last_error_code`	`sekejap.last_error_code()`, and `error.code`
`sekejap_string_free`	inside the wrapper: every returned string is copied and freed once
`sekejap_put`	`db.put(collection, key, document)`
`sekejap_put_many`	`db.put_many(collection, rows)` — a dict, pairs, or `{"key", "doc"}` objects
`sekejap_get`	`db.get(collection, key)` → `dict` or `None`
`sekejap_exists`	`db.exists(collection, key)`
`sekejap_delete`	`db.delete(collection, key)`
`sekejap_scan_open`	`db.scan(collection, page_rows=0)`
`sekejap_scan_next`	`scan.next_page()`, `scan.pages()`, `iter(scan)`
`sekejap_scan_close`	`scan.close()`
`sekejap_execute`	`db.execute(sql, params)` → rows moved
`sekejap_query`	`db.query(sql, params)` → `list[dict]`
`sekejap_explain`	`db.explain(sql, params)`
`sekejap_prepare`	`db.prepare(sql)`
`sekejap_stmt_query`	`statement.query(params)`
`sekejap_stmt_execute`	`statement.execute(params)`
`sekejap_stmt_rebindable`	`statement.rebindable` → `True` / `False` / `None` (not bound yet)
`sekejap_stmt_free`	`statement.close()`
`sekejap_query_open`	`db.stream(sql, params, page_rows=0)`
`sekejap_query_next`	`scan.next_page()`
`sekejap_query_close`	`scan.close()`
`sekejap_link`	`db.link(from_collection, from_key, edge_type, to_collection, to_key)`
`sekejap_link_with`	the same call with `properties={...}`
`sekejap_unlink`	`db.unlink(...)`
`sekejap_neighbours`	`db.neighbours(collection, key, edge_type, direction, limit)`
`sekejap_create_collection`	`db.create_collection(name, fields)`
`sekejap_drop_collection`	`db.drop_collection(name)`
`sekejap_collections`	`db.collections()`
`sekejap_describe`	`db.describe(collection)` → `dict` or `None`
`sekejap_count_rows`	`db.count_rows(collection)`
`sekejap_scan_count_rows`	`db.scan_count_rows(collection)`
`sekejap_scan_count_edges`	`db.scan_count_edges()`
`sekejap_tx_begin`	`db.transaction()`
`sekejap_tx_put`	`tx.put(collection, key, document)`
`sekejap_tx_delete`	`tx.delete(collection, key)`
`sekejap_tx_link`	`tx.link(...)`
`sekejap_tx_execute`	`tx.execute(sql, params)`
`sekejap_tx_commit`	`tx.commit()`, or a clean exit from `with db.transaction()`
`sekejap_tx_rollback`	`tx.rollback()`, or an exception inside that block
`sekejap_checkpoint`	`db.checkpoint()` → `True` folded, `False` deferred
`sekejap_publish`	`db.publish()`
`sekejap_storage`	`db.storage()`
`sekejap_statement_timeout_ms`	`db.statement_timeout_ms(ms)`
`sekejap_cancel`	`db.cancel()`
`sekejap_clear_interrupt`	`db.clear_interrupt()`
`sekejap_subscribe`	`db.subscribe()`
`sekejap_next_change`	`db.next_change(subscription, timeout_ms=0)`
`sekejap_unsubscribe`	`db.unsubscribe(subscription)`
`sekejap_open_memory`	`sekejap.open_memory()` — refused: sekejap is disk-first
`sekejap_trim_memory`	`db.trim_memory()` — refused: nothing proportional to rows is held
`sekejap_compact`	`db.compact()` — refused: there is no payload-rewriting compaction
`sekejap_show`	`db.show(statement)` — refused: `collections()` and `describe()` answer as data

The four refusals keep their names so the reason arrives as a sentence rather than as an AttributeError.

Service mode

Db.open_service(path) is one writer, parallel readers on a published snapshot, and the commit-time change feed. Every service call on a single-mode handle is refused by name.

db = Db.open_service("./data")
subscription = db.subscribe()
db.put("venues", "the_tote", {"name": "The Tote"})
event = db.next_change(subscription, timeout_ms=1000)
print(event["sequence"], event["keys"])

pandas

db.df is a namespace, and pandas is imported only when you touch it.

frame = db.df.query("SELECT _key, name, capacity FROM venues")
db.df.put(frame, "venues")          # the index is the key

A shell

python -m sekejap ./data                    # a prompt
python -m sekejap ./data "SELECT * FROM venues"

Running the tests

SEKEJAP_LIBRARY=/path/to/libsekejap.dylib make test

What changed from 0.16

The 0.16 package was a PyO3 extension module over CoreDB, and its API is gone rather than renamed:

DB, Hit and EdgeHit are gone. A row is addressed by collection and key, not by one collection/key slug string, and a query answers plain dict rows keyed by column name.
DB() with no argument opened an in-memory database. There is none: sekejap.open_memory() exists only to refuse, by name, with the reason.
db.show("SHOW TABLES") is refused; db.collections() and db.describe(name) answer the same questions as data.
trim_memory and memory_report are refused: the buffer pool is bounded at open and there is nothing proportional to rows to give back.
FROM MATCH, PATH_*, SHORTEST and the rest of the 0.16 graph dialect are SQL questions now, answered or refused by name by sekejap-lang.

Code written against 0.16 fails at import rather than silently meaning something else.

Release files for sekejap 0.17.1

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

Source distribution (sdist)

Source distribution for sekejap 0.17.1
File	Size	Uploaded
sekejap-0.17.1.tar.gz	33.6 kB	Sep 23, 2026	Details

Built distributions (wheels)

Table of built distributions (wheels) for sekejap 0.17.1
File	Interpreter	ABI	Platform	Reset
sekejap-0.17.1-py3-none-win_amd64.whl 2.1 MB Sep 23, 2026	Python 3	none	Windows x86-64	Details
sekejap-0.17.1-py3-none-manylinux_2_28_x86_64.whl 11.9 MB Sep 23, 2026	Python 3	none	Linux glibc 2.28+ x86-64	Details
sekejap-0.17.1-py3-none-manylinux_2_28_aarch64.whl 10.3 MB Sep 23, 2026	Python 3	none	Linux glibc 2.28+ ARM64	Details
sekejap-0.17.1-py3-none-macosx_11_0_arm64.whl 2.2 MB Sep 23, 2026	Python 3	none	macOS 11.0+ ARM64	Details
sekejap-0.17.1-py3-none-macosx_10_12_x86_64.whl 2.4 MB Sep 23, 2026	Python 3	none	macOS 10.12+ x86-64	Details

Total release size: 28.9 MB

Release files / sekejap-0.17.1.tar.gz

Download URL	sekejap-0.17.1.tar.gz
Size	33.6 kB
Tags	Source
SHA-256 checksum How to use checksums	`ee282ebd4dce2a6446c44decdf1a61d8b53f099525a308e56d28dad70df8a15e`
BLAKE2b-256 checksum How to use checksums	`229c042a24dfc161a19ff90375600a0be5f82c0ba3e413fb98c9e5c0c9677d81`
Upload date	Sep 23, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

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.

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/sekejapdb/sekejap
Publishing commit: github.com/sekejapdb/sekejap/tree/655959efe213273987ea5a3f85a03fc414c3182a

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/655959efe213273987ea5a3f85a03fc414c3182a/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35823607824/attempts/1

Artifact

Subject: sekejap-0.17.1.tar.gz
SHA-256 checksum: ee282ebd4dce2a6446c44decdf1a61d8b53f099525a308e56d28dad70df8a15e Verifying attestations

Release files / sekejap-0.17.1-py3-none-win_amd64.whl

Download URL	sekejap-0.17.1-py3-none-win_amd64.whl
Size	2.1 MB
Tags	Python 3 Windows x86-64
SHA-256 checksum How to use checksums	`f0b2ada0f384e8b67fba66f386f14349da40c2f52819128b4564f83078e7f109`
BLAKE2b-256 checksum How to use checksums	`2d816e9db2de13214ddb17bd4864a7e1d58da24839242751194027d4823f9b4f`
Upload date	Sep 23, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/sekejapdb/sekejap
Publishing commit: github.com/sekejapdb/sekejap/tree/655959efe213273987ea5a3f85a03fc414c3182a

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/655959efe213273987ea5a3f85a03fc414c3182a/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35823607824/attempts/1

Artifact

Subject: sekejap-0.17.1-py3-none-win_amd64.whl
SHA-256 checksum: f0b2ada0f384e8b67fba66f386f14349da40c2f52819128b4564f83078e7f109 Verifying attestations

Release files / sekejap-0.17.1-py3-none-manylinux_2_28_x86_64.whl

Download URL	sekejap-0.17.1-py3-none-manylinux_2_28_x86_64.whl
Size	11.9 MB
Tags	Linux glibc 2.28+ x86-64 Python 3
SHA-256 checksum How to use checksums	`2f193aa589f16122427f115058fca668bbcf9d79ef54503ee3a0b0116144858d`
BLAKE2b-256 checksum How to use checksums	`64e2394bda50a11138886e27d9ff9c1297b03f0af44340fe0601f83ad9b2e1f5`
Upload date	Sep 23, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/sekejapdb/sekejap
Publishing commit: github.com/sekejapdb/sekejap/tree/655959efe213273987ea5a3f85a03fc414c3182a

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/655959efe213273987ea5a3f85a03fc414c3182a/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35823607824/attempts/1

Artifact

Subject: sekejap-0.17.1-py3-none-manylinux_2_28_x86_64.whl
SHA-256 checksum: 2f193aa589f16122427f115058fca668bbcf9d79ef54503ee3a0b0116144858d Verifying attestations

Release files / sekejap-0.17.1-py3-none-manylinux_2_28_aarch64.whl

Download URL	sekejap-0.17.1-py3-none-manylinux_2_28_aarch64.whl
Size	10.3 MB
Tags	Linux glibc 2.28+ ARM64 Python 3
SHA-256 checksum How to use checksums	`df15f09ce1ef0541ddf7570c3962f826fea68224c09ab50007b846af137d1a6a`
BLAKE2b-256 checksum How to use checksums	`04f302bcf35a29b47d7d89c605cb58b13aa4fbbef95eeaf06b02835b0070e09c`
Upload date	Sep 23, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/sekejapdb/sekejap
Publishing commit: github.com/sekejapdb/sekejap/tree/655959efe213273987ea5a3f85a03fc414c3182a

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/655959efe213273987ea5a3f85a03fc414c3182a/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35823607824/attempts/1

Artifact

Subject: sekejap-0.17.1-py3-none-manylinux_2_28_aarch64.whl
SHA-256 checksum: df15f09ce1ef0541ddf7570c3962f826fea68224c09ab50007b846af137d1a6a Verifying attestations

Release files / sekejap-0.17.1-py3-none-macosx_11_0_arm64.whl

Download URL	sekejap-0.17.1-py3-none-macosx_11_0_arm64.whl
Size	2.2 MB
Tags	Python 3 macOS 11.0+ ARM64
SHA-256 checksum How to use checksums	`aa9786a49a7a74e463b0f89408af229ebe23bc2fd1a89c13049bf231efd2b648`
BLAKE2b-256 checksum How to use checksums	`1acb50127f6fcef4c37b1e43ed4ab53cd01392b9417e9fa2fbf3c50de644f28b`
Upload date	Sep 23, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/sekejapdb/sekejap
Publishing commit: github.com/sekejapdb/sekejap/tree/655959efe213273987ea5a3f85a03fc414c3182a

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/655959efe213273987ea5a3f85a03fc414c3182a/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35823607824/attempts/1

Artifact

Subject: sekejap-0.17.1-py3-none-macosx_11_0_arm64.whl
SHA-256 checksum: aa9786a49a7a74e463b0f89408af229ebe23bc2fd1a89c13049bf231efd2b648 Verifying attestations

Release files / sekejap-0.17.1-py3-none-macosx_10_12_x86_64.whl

Download URL	sekejap-0.17.1-py3-none-macosx_10_12_x86_64.whl
Size	2.4 MB
Tags	Python 3 macOS 10.12+ x86-64
SHA-256 checksum How to use checksums	`19579997a75d64152e046891f1d10bb1bd7b8e0346fbdf3e29f8862533dcf848`
BLAKE2b-256 checksum How to use checksums	`5798c2cf5b4e2a70eb3c49115a67bfb5a7884dce37b8ef188fc5c873d07f416e`
Upload date	Sep 23, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/sekejapdb/sekejap
Publishing commit: github.com/sekejapdb/sekejap/tree/655959efe213273987ea5a3f85a03fc414c3182a

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/655959efe213273987ea5a3f85a03fc414c3182a/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35823607824/attempts/1

Artifact

Subject: sekejap-0.17.1-py3-none-macosx_10_12_x86_64.whl
SHA-256 checksum: 19579997a75d64152e046891f1d10bb1bd7b8e0346fbdf3e29f8862533dcf848 Verifying attestations