Skip to main content

sqlite-predict

Prediction as a SQL primitive for SQLite: forecast(), detect_anomalies(), predict(). The wheel bundles the zero-dependency loadable extension for your platform.

import sqlite3
import sqlite_predict

db = sqlite3.connect(":memory:")
sqlite_predict.load(db)

db.execute("CREATE TABLE readings(ts TEXT, value REAL)")
# ... insert rows ...

# forecast() is an aggregate: your query supplies the rows, and each
# group returns one JSON document
doc = db.execute("SELECT forecast(ts, value, 24) FROM readings").fetchone()[0]
print(doc)

See the project README for the full SQL surface, models, and benchmarks.

Metadata

Release files for sqlite-predict 0.2.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 sqlite-predict 0.2.1
File Size Uploaded Provenance Actions
sqlite_predict-0.2.1.tar.gz 273.7 kB With provenance Details for sqlite_predict-0.2.1.tar.gz

Built distributions (wheels)

Table of built distributions (wheels) for sqlite-predict 0.2.1
File Interpreter ABI Platform Actions
sqlite_predict-0.2.1-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl Python 3 none Linux glibc 2.17+ x86-64, Linux glibc 2.28+ x86-64 Details for sqlite_predict-0.2.1-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
sqlite_predict-0.2.1-py3-none-macosx_11_0_arm64.whl Python 3 none macOS 11.0+ ARM64 Details for sqlite_predict-0.2.1-py3-none-macosx_11_0_arm64.whl

Total release size: 466.2 kB

Release files / sqlite_predict-0.2.1.tar.gz

Download URL sqlite_predict-0.2.1.tar.gz
Size 273.7 kB
Tags Source
SHA-256 checksum
How to use checksums
694d6326b361b60570c1ec49bc47d6edbf9e4a836af78bd10f304ab5fdefd561
BLAKE2b-256 checksum
How to use checksums
b2a1f484ac32aed554cb6544e675c06c6f39faf288dd30b98ff2bd4b200b7006
Upload date
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.

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 Aug 3, 2026.

Transparency log

Release files / sqlite_predict-0.2.1-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl

Download URL sqlite_predict-0.2.1-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
Size 96.7 kB
Tags Linux glibc 2.17+ x86-64 Linux glibc 2.28+ x86-64 Python 3
SHA-256 checksum
How to use checksums
e6aa7c7e41c47732dca6e5eb12dd2a057b31a9073607af87d68793a834605902
BLAKE2b-256 checksum
How to use checksums
59768df93b595485666260a4822de74f42acb8a016e67369094fefeaf1897e57
Upload date
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.

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 Aug 3, 2026.

Transparency log

Release files / sqlite_predict-0.2.1-py3-none-macosx_11_0_arm64.whl

Download URL sqlite_predict-0.2.1-py3-none-macosx_11_0_arm64.whl
Size 95.7 kB
Tags Python 3 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
183507521706d10f627611fa21a4e9f835ea77c2653c03e5d0bbc45864d22795
BLAKE2b-256 checksum
How to use checksums
f95537eeaa692883360a2be1efbe49d74170dfab9a5b54d0e932713006f547a5
Upload date
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.

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 Aug 3, 2026.

Transparency log

Security for sqlite-predict 0.2.1

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 3 files in this release have been uploaded with provenance metadata.

Select from 3 files

Attestation for sqlite_predict-0.2.1.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 Aug 3, 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