C++20 columnar engine with Python bindings. kdb+-like joins, SIMD aggregations,
and real-time streaming — all from a single pip install.
Real benchmarks on 1M-row datasets. No tricks, no cherry-picking. wayyDB's C++20 columnar engine with AVX2 SIMD is simply faster.
Connect to Wayy Cloud, create tables, stream real-time market data, and run aggregations — all from your terminal. No boilerplate.
From pip install to as-of join in 30 seconds.
import wayy_db as wdb
import numpy as np
# Create trades table from numpy arrays
trades = wdb.from_dict({
"timestamp": np.array([1000, 2000, 3000], dtype=np.int64),
"symbol": np.array([0, 1, 0], dtype=np.uint32),
"price": np.array([150.25, 380.50, 151.00]),
}, name="trades", sorted_by="timestamp")
# As-of join — O(n log m)
result = wdb.ops.aj(trades, quotes, on=["symbol"], as_of="timestamp")
# Zero-copy NumPy (no data copied!)
prices = trades["price"].to_numpy()
# SIMD-accelerated aggregations
avg_price = wdb.ops.avg(trades["price"])
# Window functions
mavg = wdb.ops.mavg(trades["price"], window=20)
ema = wdb.ops.ema(trades["price"], alpha=0.1)Every feature designed around the workflows of quantitative researchers and data engineers.
AVX2-accelerated sum, avg, min, max, and count. Crunches 1M rows in under a millisecond on modern hardware.
kdb+-style temporal joins that match the latest record as of a given timestamp. Essential for aligning trades with quotes.
WebSocket-based ingestion with pub/sub fan-out. Stream market data directly into tables with sub-millisecond latency.
Column-oriented layout with memory-mapped files. Load 1M rows from disk in 0.05ms. Cache-friendly access patterns throughout.
Full FastAPI-powered REST interface with WebSocket pub/sub. Query, insert, and subscribe from any language.
Temporal window joins for rolling analysis. Compute features over sliding time windows without leaving the database.
Install the package with optional CLI and API extras.
pip install wayy-db[cli,api]
Or run locally. Your data, your infrastructure.
wayy connect https://api.wayydb.com
Create tables, stream data, run joins and aggregations.
import wayy_db as wdb