Projections
Wide, read-optimized reconstructions of entity state assembled from attribute tables.
Projections are wide, read-optimized reconstructions of entity state. Where attribute tables store each attribute as its own relation, a projection assembles them into a single row per entity so the common read is a scan of one relation.
Latest-read projections
The default SELECT over an attribute-backed entity reads its projection — the
current wide row per entity — rather than merging attribute relations at query
time.
-- reads the projection, not a live K-way merge
SELECT * FROM accounts WHERE account_id = :id;Projection freshness is an asynchronous lag behind the write path: the projection catches up shortly after writes land. Point-in-time and historical reads reconstruct exact state from the attribute tables directly.
Reconstruction
For historical or AS OF reads, NYXDB reconstructs state by merging the relevant
attribute relations with the requested cutoff pushed down, so only the needed
history is touched.