Complete event history
Every event kept as written, in one durable table.
Keep every security event, know the state of every entity right now, and run detections as queries that stay open.
The problem
Security telemetry never stops: authentication events, network flows, endpoint signals and audit records arrive from every system you run, and the questions that matter are about the last few seconds. Which account just changed behaviour, which host is talking to a new destination, which key was used from two places at once.
The usual answer spreads one investigation across a log store for history, a stream processor for rules, a cache for entity state and a ticketing tool for the trail. Each hand-off adds delay, and every copy is a place where the state an analyst reads disagrees with the state that raised the alert.
The fit is one engine that keeps the raw events durable, maintains per-entity state from them, evaluates detections continuously over the same writes, and lets you reread any table exactly as it was when a decision was made.
Where NYXDB fits
Architecture
Events append in full; transformations fold them into per-entity risk and activity state; STREAM SELECT runs detections over windows and pushes hits to responders; VERSIONED tables answer AS OF COMMIT reads for forensics.
Authentication, flow and endpoint events append through SQL, write batches or native bulk frames.
Transformations keep per-user, per-host and per-key counters and last-seen state in keyed tables.
STREAM SELECT over TUMBLE or HOP windows evaluates burst, novelty and threshold rules as events arrive.
VERSIONED tables keep every accepted version; AS OF COMMIT reads the state exactly as it was at the alert.
In practice
STREAM SELECT window_start, window_end, sender, COUNT() AS transfersFROM HOP(transfers, transferred_at, INTERVAL 10 SECONDS, INTERVAL 1 MINUTE)GROUP BY window_start, window_end, senderEMIT AFTER WINDOW CLOSE;SELECT address, token, amountFROM balances AS OF COMMIT 42WHERE chain_id = 1;The examples use the same two tables on every page. See the SQL reference for full syntax.
Capabilities
Every event kept as written, in one durable table.
Per-user, per-host and per-key state maintained from every event.
TUMBLE / HOP / SESSION windows in STREAM SELECT, pushed as they fire.
AS OF COMMIT reads a table exactly as it was at the alert.
Learn more
Explore the fraud and observability solutions, or run a node.