SciDuck

A thin DuckDB layer for managing versioned scientific data.

Each variable is stored in its own table. Variables are associated with a hierarchical dataset schema (e.g. subject -> session -> trial) and can be saved at any level of that hierarchy. Multiple versions of each variable are supported natively.

All data -- including arrays -- is stored in queryable DuckDB types (LIST, nested LIST, JSON) so the database can be inspected with DBeaver or any DuckDB-compatible viewer.

Usage

from sciduckdb import SciDuck

duck = SciDuck("data.duckdb", dataset_schema=["subject", "session"])
duck.save("MyVar", data, subject="S01", session=1)
loaded = duck.load("MyVar", subject="S01", session=1)

Features

Three save modes: DataFrame with schema columns (Mode A), single entry via kwargs (Mode B), or dict mapping tuples to values (Mode C)
Automatic type inference: Maps Python/numpy types to DuckDB types
Round-trip restoration: Metadata tracks original types for lossless load
Version management: Automatic version numbering, duplicate hash detection
Variable groups: Organize variables into named groups
Schema validation: Validates dataset schema consistency across sessions

Note: all schema key values are coerced to strings before storage.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sciduckdb-0.1.9.dev0.tar.gz (16.5 kB view details)

Uploaded Jul 22, 2026 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

sciduckdb-0.1.9.dev0-py3-none-any.whl (17.0 kB view details)

Uploaded Jul 22, 2026 Python 3

File details

Details for the file sciduckdb-0.1.9.dev0.tar.gz.

File metadata

Download URL: sciduckdb-0.1.9.dev0.tar.gz
Upload date: Jul 22, 2026
Size: 16.5 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for sciduckdb-0.1.9.dev0.tar.gz
Algorithm	Hash digest
SHA256	`53b2912957a367a538c1c0414221ed87574ff6d85eaa84999ce0554fdba04e9d`
MD5	`9232532014273dc12f9309e7f2fdbccd`
BLAKE2b-256	`4cbf01cbb0cbf00ca51a049b638eb2ae8f53758bbe526114a5e2a9d9cfcf391d`

See more details on using hashes here.

Provenance

The following attestation bundles were made for sciduckdb-0.1.9.dev0.tar.gz:

Publisher: publish.yml on mtillman14/scistack

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: sciduckdb-0.1.9.dev0.tar.gz
- Subject digest: 53b2912957a367a538c1c0414221ed87574ff6d85eaa84999ce0554fdba04e9d
- Sigstore transparency entry: 2219992524
- Sigstore integration time: Jul 22, 2026
Source repository:
- Permalink: mtillman14/scistack@9b8f633810fdfa3efb7a5d245e97f7350ba1d7a2
- Branch / Tag: refs/tags/v0.1.8
- Owner: https://github.com/mtillman14
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: publish.yml@9b8f633810fdfa3efb7a5d245e97f7350ba1d7a2
- Trigger Event: push