Metadata-Version: 2.1
Name: rtbot-sql
Author: Katenaria
Author-email: services@katenaria.com
Home-page: https://rtbot.dev
License: Proprietary
Description-Content-Type: text/markdown
Summary: Real-time SQL computation engine for streaming numerical data
Project-URL: Documentation, https://rtbot.dev/docs
Project-URL: Source, https://github.com/rtbot-dev/rtbot-sql
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Science/Research
Classifier: License :: Other/Proprietary License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.12
Classifier: Programming Language :: Python :: 3.13
Classifier: Topic :: Scientific/Engineering
Requires-Python: >=3.12
Version: 0.1.13

# RtBot SQL

Real-time SQL computation engine for streaming numerical data. Write SQL to define streaming pipelines — RtBot compiles them into high-performance C++ programs that process data incrementally, one message at a time.

## Quick start

```python
from rtbot_sql import RtBotSql

sql = RtBotSql()
sql.execute("CREATE STREAM sensors (temperature DOUBLE, pressure DOUBLE)")
sql.execute("""
  CREATE MATERIALIZED VIEW alerts AS
    SELECT temperature, pressure,
           MOVING_AVERAGE(temperature, 50) AS avg_temp,
           MOVING_STD(temperature, 50) AS std_temp
    FROM sensors
    WHERE ABS(temperature - MOVING_AVERAGE(temperature, 50)) > 2 * MOVING_STD(temperature, 50)
""")

import pandas as pd
df = pd.read_csv("sensor_history.csv")
sql.insert_dataframe("sensors", df)
results = sql.execute("SELECT * FROM alerts")
```

## Features

- **One language, all stages** — the SQL you write in a notebook is the same SQL that runs in production
- **Incremental execution** — each new data point updates pipeline state in constant time
- **Deterministic** — same input always produces the same output, regardless of timing
- **High performance** — native C++ engine with Python bindings via pybind11

## Documentation

- [Getting Started](https://rtbot.dev/docs/user-guide/getting-started)
- [Python Quickstart](https://rtbot.dev/docs/user-guide/quickstart-python)
- [SQL Reference](https://rtbot.dev/docs/reference/rtbot-sql/overview)

## License

Proprietary. See [rtbot.dev](https://rtbot.dev) for licensing options.

