Guides
Guides
Step-by-step guides that build something on NYXDB end to end: live dashboards, feature stores, audits over history and migrations.
Each guide starts from an installed node and ends with something running: the tables, the derived state and the client that reads it. The getting-started guide covers the install, and the SQL reference has every statement the guides use.
Build
Build a live dashboardKeep a dashboard exact as writes land: a streaming query, a materialized view and a client that subscribes once.Stream changes to clientsFan one streaming query out to many clients over WebSocket sessions, with demand and cancellation.Keep a feature store freshMaintain feature tables with transformations and read point-in-time training sets from history.Audit with point-in-time readsAnswer what a table said at a given commit, and who wrote it, with AS OF COMMIT reads.Replay history into a new tableRebuild a derived table from the full history of its source with one transformation.Model events, state and historyChoose append, upsert and versioned tables for one domain, and the attribute groups that write them.Tune storage profilesPick row, columnar or hybrid storage per table, and the indexes that match the reads.Migrate from PostgreSQLMove tables, writes and the queries behind an application from PostgreSQL to NYXDB.Migrate from ClickHouseMove analytical tables and materialized views from ClickHouse, and keep them fresh from writes.