Overview

⚡ Fastest SQL ETL pipeline in a single C++ binary, built for stream processing, observability, analytics and AI/ML Timeplus unifies real-time streaming and historical data in a single binary, implementing mission-critical workloads to act on fast changing events and insights, deployable from the edge to the cloud. Fastest SQL pipeline engine for stream processing, analytics, observability and AI The project has 2K+ GitHub stars and is licensed under Apache-2.0.

Getting Started

Source: GitHub README

-- Read from AWS MSK using IAM Role
CREATE EXTERNAL STREAM aws_msk_stream (
  device string,
  temperature float
)
SETTINGS
    type='kafka',
    brokers='prefix.kafka.us-west-2.amazonaws.com:9098',
    topic='topic',
    security_protocol='SASL_SSL',
    sasl_mechanism='AWS_MSK_IAM';

-- Write to ClickHouse
CREATE EXTERNAL TABLE ch_aiven
SETTINGS type='clickhouse',
            address='abc.aivencloud.com:28851',
            user='avnadmin',
            password='..',
            secure=true,
            table='events';

-- Setup a long-running materialized view to write aggregated data to ClickHouse
CREATE MATERIALIZED VIEW mv_msk2ch INTO ch_aiven AS
SELECT window_start as timestamp, device, avg(temperature) as avg_temperature
FROM tumble(aws_msk_stream, 10s) GROUP BY window_start, device;

-- Create a stream with random data
CREATE RANDOM STREAM devices(
  device string default 'device'||to_string(rand()%4),
  temperature float default rand()%1000/10);

-- Run the streaming SQL
SELECT device, count(*), min(temperature), max(temperature)
FROM devices GROUP BY device;

Normalized Features

Source: tool-features-normalized.json

brew, clickhouse, docker, docker compose, kubernetes, mongodb, mysql, postgresql, rest api, webhooks.

Deploy

Docker

Self-host with Docker Compose

Coolify

One-click via Coolify panel

Elestio

Managed hosting from $9/mo

PikaPods

Simple managed hosting

Features

Integrations & APIs

REST API
Webhooks

Replaces

Compare Timeplus

Superset vs

Timeplus

Both are analytics tools. Superset has 7 unique features, Timeplus has 3.

Related Analytics & Business Intelligence Tools

View all 176 →

Superset

71K

Apache Superset is an open-source data exploration and visualization platform — connect to any SQL database, build interactive dashboards, and run ad-hoc queries.

analytics Apache-2.0

OpenBB

63K

The open-source AI workspace for finance — connect proprietary and public data, build custom analytics apps, and deploy AI agents on your own infrastructure.

analytics

Metabase

46K

Open-source business intelligence that lets anyone in your company ask questions and learn from data. Build dashboards, run queries, and share insights without SQL.

analytics

ClickHouse

46K

Ultra-fast column-oriented database for real-time analytics. Process billions of rows per second with SQL. Open-source alternative to Snowflake and BigQuery.

analytics Apache-2.0