Reference

The SQL surface, the CLI and the Python binding, with the output each one actually produces.

Ubik runs SQL over a stream as a single process. This is the reference for the three surfaces that expose it: the SQL dialect, the ubik CLI, and the embeddable Python module.

Every response shown on these pages came out of the shipped binary. Where a page shows output, that is the output.

Start here

Windows

TUMBLE, HOP and SESSION, the window_start output column, and the malformed calls the planner refuses before it binds.

Pipelines

Named, supervised jobs, one process each, resumed from checkpoint across a restart.

Python

import ubik, run streaming SQL in-process over libubik, results as pyarrow, pandas or polars.

Install

brew tap magiclex/ubik && brew trust magiclex/ubik
brew install magiclex/ubik/ubik

pip install ubik-sql

Linux x86_64, Linux aarch64 and macOS arm64 (macOS 12 or later). Checksum verified tarballs are listed on the download page.