# 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](/docs/getting-started) covers the install, and the
[SQL reference](/docs/sql) has every statement the guides use.

## Build

- [Build a live dashboard](https://nyxdb.io/docs/guides/live-dashboard/) — Keep a dashboard exact as writes land: a streaming query, a materialized view and a client that subscribes once.
- [Stream changes to clients](https://nyxdb.io/docs/guides/stream-to-clients/) — Fan one streaming query out to many clients over WebSocket sessions, with demand and cancellation.
- [Keep a feature store fresh](https://nyxdb.io/docs/guides/feature-store/) — Maintain feature tables with transformations and read point-in-time training sets from history.
- [Audit with point-in-time reads](https://nyxdb.io/docs/guides/point-in-time-audit/) — Answer what a table said at a given commit, and who wrote it, with AS OF COMMIT reads.
- [Replay history into a new table](https://nyxdb.io/docs/guides/replay-history/) — Rebuild a derived table from the full history of its source with one transformation.
- [Model events, state and history](https://nyxdb.io/docs/guides/model-events-state-history/) — Choose append, upsert and versioned tables for one domain, and the attribute groups that write them.
- [Tune storage profiles](https://nyxdb.io/docs/guides/tune-storage-profiles/) — Pick row, columnar or hybrid storage per table, and the indexes that match the reads.
- [Migrate from PostgreSQL](https://nyxdb.io/docs/guides/migrate-from-postgres/) — Move tables, writes and the queries behind an application from PostgreSQL to NYXDB.
- [Migrate from ClickHouse](https://nyxdb.io/docs/guides/migrate-from-clickhouse/) — Move analytical tables and materialized views from ClickHouse, and keep them fresh from writes.

---

Source: https://nyxdb.io/docs/guides/