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.

Download files

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

Source Distribution

sqlite_predict-0.1.0.tar.gz (263.0 kB view details)

Uploaded Source

Built Distributions

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

sqlite_predict-0.1.0-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (96.9 kB view details)

Uploaded Python 3manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

sqlite_predict-0.1.0-py3-none-macosx_11_0_arm64.whl (89.8 kB view details)

Uploaded Python 3macOS 11.0+ ARM64

File details

Details for the file sqlite_predict-0.1.0.tar.gz.

File metadata

  • Download URL: sqlite_predict-0.1.0.tar.gz
  • Upload date:
  • Size: 263.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for sqlite_predict-0.1.0.tar.gz
Algorithm Hash digest
SHA256 17746ada24db461117ecfc8a4ce15aeb252f4786d44c48f85da7c025999db2a5
MD5 06c8d4413e63333dfd5de57e900242e9
BLAKE2b-256 2ad2260c1e3640604c75e041364cacec0f7970a1563f171536b47d5582a3cd0a

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlite_predict-0.1.0.tar.gz:

Publisher: wheels.yml on PureStorage-OpenConnect/sqlite-predict

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

File details

Details for the file sqlite_predict-0.1.0-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for sqlite_predict-0.1.0-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 0e59dec95d53a48285a247f98cc1228eb54ae91701a7e1edc44315631bf5cddd
MD5 f950a5171587dfdf12be089cfaa7bc3a
BLAKE2b-256 8ac859bea7ec1789e1b2f6538c2edb95f95377d651b6d770c53286570b98bb34

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlite_predict-0.1.0-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl:

Publisher: wheels.yml on PureStorage-OpenConnect/sqlite-predict

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

File details

Details for the file sqlite_predict-0.1.0-py3-none-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for sqlite_predict-0.1.0-py3-none-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 3175986fa1076b1aaf528c899553d546316ec427bac0218caf04137c99e13fdf
MD5 de6d45bc970c7314369ab9bfc39624e2
BLAKE2b-256 cbc9ccbcb7921b13fc83f03380022ecb25fac1bc88e58ad131c2337eeadc8e11

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlite_predict-0.1.0-py3-none-macosx_11_0_arm64.whl:

Publisher: wheels.yml on PureStorage-OpenConnect/sqlite-predict

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

Release history Release notifications | RSS feed

0.2.1

3 files

0.2.0

3 files

This release

0.1.0 This release

3 files

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