[DRAFT]This page is not published. Only visible in development mode.

Views

Views are derived datasets that stay in sync with their source tables. ReifyDB supports deferred views (eventually consistent) and transactional views (updated within the same transaction as the source data).

Deferred View

CREATE NAMESPACE vw_d;
CREATE TABLE vw_d::employees {
  id: int4,
  name: utf8,
  active: bool
};
CREATE DEFERRED VIEW vw_d::active_employees {
  id: int4,
  name: utf8
} AS {
  FROM vw_d::employees
  FILTER active == true
  MAP { id: id, name: name }
};
INSERT vw_d::employees [
  { id: 1, name: 'Alice', active: true },
  { id: 2, name: 'Bob', active: false },
  { id: 3, name: 'Carol', active: true }
];
FROM vw_d::active_employees

Deferred views are incrementally maintained. They define their own schema and a query that produces it.

Transactional View

CREATE NAMESPACE vw_t;
CREATE TABLE vw_t::users {
  id: int4,
  name: utf8,
  active: bool
};
CREATE VIEW vw_t::active_users {
  id: int4,
  name: utf8
} AS {
  FROM vw_t::users
  FILTER active == true
  MAP { id: id, name: name }
};
INSERT vw_t::users [
  { id: 1, name: 'Alice', active: true },
  { id: 2, name: 'Bob', active: false }
];
FROM vw_t::active_users

Transactional views update atomically with the source data. When you insert a row, the view reflects it immediately.