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.
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file sqlite_predict-0.2.0.tar.gz.
File metadata
- Download URL: sqlite_predict-0.2.0.tar.gz
- Upload date:
- Size: 272.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
5b6dbe73b1ccbdcd18034d455c681c2cdec0f4d8c6f3d92ca42ecb8569b76808
|
|
| MD5 |
1c44d2cfd9f4cdf5f35a43bdc5b22448
|
|
| BLAKE2b-256 |
1c415d0749fd408fad9a03cf2ec856337bc1c30d87f013348da533bf5cb26d87
|
Provenance
The following attestation bundles were made for sqlite_predict-0.2.0.tar.gz:
Publisher:
wheels.yml on PureStorage-OpenConnect/sqlite-predict
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_predict-0.2.0.tar.gz -
Subject digest:
5b6dbe73b1ccbdcd18034d455c681c2cdec0f4d8c6f3d92ca42ecb8569b76808 - Sigstore transparency entry: 2297031663
- Sigstore integration time:
-
Permalink:
PureStorage-OpenConnect/sqlite-predict@d99caf8f2cc6ce749fa5f9d338797dbc7ae85933 -
Branch / Tag:
refs/tags/v0.2.0 - Owner: https://github.com/PureStorage-OpenConnect
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
wheels.yml@d99caf8f2cc6ce749fa5f9d338797dbc7ae85933 -
Trigger Event:
push
-
Statement type:
File details
Details for the file sqlite_predict-0.2.0-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl.
File metadata
- Download URL: sqlite_predict-0.2.0-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
- Upload date:
- Size: 96.3 kB
- Tags: Python 3, manylinux: glibc 2.17+ x86-64, manylinux: glibc 2.28+ x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
2b5cf6fdf477f909ea94577b39febe44eec883eca2c8364611426d5f16c7dc41
|
|
| MD5 |
8d7b399659cd9699beea23088e58b390
|
|
| BLAKE2b-256 |
b49b6a4c49243e66e615631e80a06ec1d8d6b1d9b6444b21c8a72b94ff9e1222
|
Provenance
The following attestation bundles were made for sqlite_predict-0.2.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
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_predict-0.2.0-py3-none-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl -
Subject digest:
2b5cf6fdf477f909ea94577b39febe44eec883eca2c8364611426d5f16c7dc41 - Sigstore transparency entry: 2297031734
- Sigstore integration time:
-
Permalink:
PureStorage-OpenConnect/sqlite-predict@d99caf8f2cc6ce749fa5f9d338797dbc7ae85933 -
Branch / Tag:
refs/tags/v0.2.0 - Owner: https://github.com/PureStorage-OpenConnect
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
wheels.yml@d99caf8f2cc6ce749fa5f9d338797dbc7ae85933 -
Trigger Event:
push
-
Statement type:
File details
Details for the file sqlite_predict-0.2.0-py3-none-macosx_11_0_arm64.whl.
File metadata
- Download URL: sqlite_predict-0.2.0-py3-none-macosx_11_0_arm64.whl
- Upload date:
- Size: 95.5 kB
- Tags: Python 3, macOS 11.0+ ARM64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
20c8efe11439f1e586177549624359599c8fefd50f00eefc2368ab59392a6960
|
|
| MD5 |
d78ff67ca62a360278205ef6952cb12a
|
|
| BLAKE2b-256 |
dbc39c1e8c43ad3e815ef4755b2913dd4f05d4ba16dbb77535d3522082819958
|
Provenance
The following attestation bundles were made for sqlite_predict-0.2.0-py3-none-macosx_11_0_arm64.whl:
Publisher:
wheels.yml on PureStorage-OpenConnect/sqlite-predict
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_predict-0.2.0-py3-none-macosx_11_0_arm64.whl -
Subject digest:
20c8efe11439f1e586177549624359599c8fefd50f00eefc2368ab59392a6960 - Sigstore transparency entry: 2297031790
- Sigstore integration time:
-
Permalink:
PureStorage-OpenConnect/sqlite-predict@d99caf8f2cc6ce749fa5f9d338797dbc7ae85933 -
Branch / Tag:
refs/tags/v0.2.0 - Owner: https://github.com/PureStorage-OpenConnect
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
wheels.yml@d99caf8f2cc6ce749fa5f9d338797dbc7ae85933 -
Trigger Event:
push
-
Statement type:
