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.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 sekejap 0.17.3
File	Size	Uploaded
sekejap-0.17.3.tar.gz	33.6 kB	Sep 24, 2026	Details

Built distributions (wheels)

Table of built distributions (wheels) for sekejap 0.17.3
File	Interpreter	ABI	Platform	Reset
sekejap-0.17.3-py3-none-win_amd64.whl 2.3 MB Sep 24, 2026	Python 3	none	Windows x86-64	Details
sekejap-0.17.3-py3-none-manylinux_2_28_x86_64.whl 2.1 MB Sep 24, 2026	Python 3	none	Linux glibc 2.28+ x86-64	Details
sekejap-0.17.3-py3-none-manylinux_2_28_aarch64.whl 2.0 MB Sep 24, 2026	Python 3	none	Linux glibc 2.28+ ARM64	Details
sekejap-0.17.3-py3-none-macosx_11_0_arm64.whl 1.9 MB Sep 24, 2026	Python 3	none	macOS 11.0+ ARM64	Details
sekejap-0.17.3-py3-none-macosx_10_12_x86_64.whl 2.1 MB Sep 24, 2026	Python 3	none	macOS 10.12+ x86-64	Details

Total release size: 10.4 MB

Release files / sekejap-0.17.3.tar.gz

Download URL	sekejap-0.17.3.tar.gz
Size	33.6 kB
Tags	Source
SHA-256 checksum How to use checksums	`713ff8a960236db1bbc3ca288a18489daeaa62412ff3499f9119dd493a2382f7`
BLAKE2b-256 checksum How to use checksums	`8e311449f6035bbee046dedd8bf2f639389a43106d44d3bcf40eff80ced40a72`
Upload date	Sep 24, 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/763acb8ca34c3d31d357c15a5207781db7d56adb

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/763acb8ca34c3d31d357c15a5207781db7d56adb/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35993891863/attempts/1

Artifact

Subject: sekejap-0.17.3.tar.gz
SHA-256 checksum: 713ff8a960236db1bbc3ca288a18489daeaa62412ff3499f9119dd493a2382f7 Verifying attestations

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

Download URL	sekejap-0.17.3-py3-none-win_amd64.whl
Size	2.3 MB
Tags	Python 3 Windows x86-64
SHA-256 checksum How to use checksums	`46bbc113318c6c0e7eb1d934b451850ac61a0053eb02d4dd1004fd162034ffab`
BLAKE2b-256 checksum How to use checksums	`b5451fcc3d1e62a55021b459e23da58ffc65ed0e59fb18f0ce8887104187d139`
Upload date	Sep 24, 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/763acb8ca34c3d31d357c15a5207781db7d56adb

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/763acb8ca34c3d31d357c15a5207781db7d56adb/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35993891863/attempts/1

Artifact

Subject: sekejap-0.17.3-py3-none-win_amd64.whl
SHA-256 checksum: 46bbc113318c6c0e7eb1d934b451850ac61a0053eb02d4dd1004fd162034ffab Verifying attestations

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

Download URL	sekejap-0.17.3-py3-none-manylinux_2_28_x86_64.whl
Size	2.1 MB
Tags	Linux glibc 2.28+ x86-64 Python 3
SHA-256 checksum How to use checksums	`426746b03ca6bc62b4ea7f6af21248149ad542559b9e6c7aed9f8e7c5ce36c21`
BLAKE2b-256 checksum How to use checksums	`ceef9779b6205b069a093fd96f5e9ac6d03a58aab50b11f321d2c8bcc1612fba`
Upload date	Sep 24, 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/763acb8ca34c3d31d357c15a5207781db7d56adb

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/763acb8ca34c3d31d357c15a5207781db7d56adb/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35993891863/attempts/1

Artifact

Subject: sekejap-0.17.3-py3-none-manylinux_2_28_x86_64.whl
SHA-256 checksum: 426746b03ca6bc62b4ea7f6af21248149ad542559b9e6c7aed9f8e7c5ce36c21 Verifying attestations

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

Download URL	sekejap-0.17.3-py3-none-manylinux_2_28_aarch64.whl
Size	2.0 MB
Tags	Linux glibc 2.28+ ARM64 Python 3
SHA-256 checksum How to use checksums	`ec1334705ceb657aad055292c0663fefb1a00efc9b2bfbea5a13b79e57728a18`
BLAKE2b-256 checksum How to use checksums	`16d194e4cdefc82db1ab6fdba42d72f68fb0d19cf376c30bd3709e78b0773001`
Upload date	Sep 24, 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/763acb8ca34c3d31d357c15a5207781db7d56adb

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/763acb8ca34c3d31d357c15a5207781db7d56adb/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35993891863/attempts/1

Artifact

Subject: sekejap-0.17.3-py3-none-manylinux_2_28_aarch64.whl
SHA-256 checksum: ec1334705ceb657aad055292c0663fefb1a00efc9b2bfbea5a13b79e57728a18 Verifying attestations

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

Download URL	sekejap-0.17.3-py3-none-macosx_11_0_arm64.whl
Size	1.9 MB
Tags	Python 3 macOS 11.0+ ARM64
SHA-256 checksum How to use checksums	`51a9dd10f10aeba1dd23556e91764a393b1bb39e33566929f998e8e855bb4360`
BLAKE2b-256 checksum How to use checksums	`8fc4d5b85b820c9f884059438af875a09241b43b3e6b497e1677521191225be2`
Upload date	Sep 24, 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/763acb8ca34c3d31d357c15a5207781db7d56adb

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/763acb8ca34c3d31d357c15a5207781db7d56adb/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35993891863/attempts/1

Artifact

Subject: sekejap-0.17.3-py3-none-macosx_11_0_arm64.whl
SHA-256 checksum: 51a9dd10f10aeba1dd23556e91764a393b1bb39e33566929f998e8e855bb4360 Verifying attestations

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

Download URL	sekejap-0.17.3-py3-none-macosx_10_12_x86_64.whl
Size	2.1 MB
Tags	Python 3 macOS 10.12+ x86-64
SHA-256 checksum How to use checksums	`709c472df76e91114e01a083cbb950def1c317bb32a3ce0cc99cb213af0831cf`
BLAKE2b-256 checksum How to use checksums	`f4443c49d52edc1306a20b406198fabb1ae368cf0bd3090e40dc234f840b39bd`
Upload date	Sep 24, 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/763acb8ca34c3d31d357c15a5207781db7d56adb

Workflow

Publishing configuration: github.com/sekejapdb/sekejap/blob/763acb8ca34c3d31d357c15a5207781db7d56adb/.github/workflows/release.yml
Publishing logs: github.com/sekejapdb/sekejap/actions/runs/35993891863/attempts/1

Artifact

Subject: sekejap-0.17.3-py3-none-macosx_10_12_x86_64.whl
SHA-256 checksum: 709c472df76e91114e01a083cbb950def1c317bb32a3ce0cc99cb213af0831cf Verifying attestations