Skip to main content

polars-hist-db

A Python library for building bitemporal data pipelines with Polars, MariaDB, and optional XTDB backend support.

It ingests data from DSV files or NATS JetStream subjects, tracks history through a typed temporal table contract, and exposes everything as strongly-typed Polars DataFrames.

Features

  • Typed uploads — push Polars DataFrames into MariaDB or XTDB with automatic type mapping between Polars, SQL, and SQLAlchemy/ADBC.
  • Typed queries — read tables back into DataFrames with column types inferred from the configured backend schema. Temporal query hints (asof, span, all) let you slice history without writing SQL.
  • YAML-driven pipelines — define scrape specifications that handle column typing, enrichment via custom transform functions, normalization across tables, and foreign-key deduction.
  • Deduplication — an audit log tracks what has already been ingested so re-runs skip previously processed files or messages.
  • Transactional ingestion — each file or message is processed in its own transaction; failures roll back cleanly without affecting other items.
  • Dual input sources — crawl directories for DSV files, or consume messages from NATS JetStream with configurable fetch/subscription strategies.
  • Delta upserts — staging tables detect changed rows, handle duplicates (take_first, take_last, error), and optionally mark disappeared rows as dropped.

Full documentation: jr200.github.io/polars-hist-db

Quick Start

uv sync
make test

Development

Development and CI use Python 3.15, selected by .python-version; uv installs that interpreter automatically. The library continues to support Python 3.12+. With the current lockfile, Python 3.15 builds pycrdt, scandir-rs, and the optional ADBC driver manager from source. Install a Rust toolchain supporting the 2024 edition and a C/C++ compiler before running uv sync --group dev --extra xtdb.

make check       # ruff + mypy
make docs        # render and preview quarto docs
make bump PART=patch
make release

License

This project is licensed under the MIT license.

Metadata

Release files for polars-hist-db 0.12.82

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

Source distribution (sdist)

Source distribution for polars-hist-db 0.12.82
File Size Uploaded Provenance
polars_hist_db-0.12.82.tar.gz 1.0 MB Without provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for polars-hist-db 0.12.82
File Interpreter ABI Platform
polars_hist_db-0.12.82-py3-none-any.whl Python 3 none any Details

Total release size: 1.2 MB

Release files / polars_hist_db-0.12.82.tar.gz

Download URL polars_hist_db-0.12.82.tar.gz
Size 1.0 MB
Tags Source
SHA-256 checksum
How to use checksums
8c37db9172d5661b9984183e92543c8acaf7c783e42b7224acb3904c0d3d0b95
BLAKE2b-256 checksum
How to use checksums
fd769029a0872f66a7c29797c8fbe4e30bac6fef4517825740ee44acbfb5338e
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.13.5 {"installer":{"name":"uv","version":"0.13.5","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

Release files / polars_hist_db-0.12.82-py3-none-any.whl

Download URL polars_hist_db-0.12.82-py3-none-any.whl
Size 176.8 kB
Tags Python 3
SHA-256 checksum
How to use checksums
57b370d3a046b3d90c59b7a326d9d65d127b4093c6ba302cf687f9c9fbb806b4
BLAKE2b-256 checksum
How to use checksums
d5b6242af5e558d50345620037e7dd546ff84d737c38cd69a6eef7b94725b96d
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.13.5 {"installer":{"name":"uv","version":"0.13.5","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

Security for polars-hist-db 0.12.82

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.

No provenance found

None of the files in this release were uploaded with provenance metadata.

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.

Release history Release notifications | RSS feed

This release

0.12.82 This release

2 release files No provenance

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