sqlite-predict 0.0.1a1

Prediction as a SQL primitive for SQLite: forecast, detect_anomalies, predict, with replayable receipts.

everpure-sqlite-predict

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

import sqlite3
from everpure import sqlite_predict

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

db.execute("CREATE TABLE readings(ts TEXT, value REAL)")
# ... insert rows ...
for row in db.execute(
    "SELECT * FROM forecast('SELECT ts, value FROM readings', 24)"
):
    print(row)

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