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

Deferred Views

Deferred views are incrementally maintained materialized views. They define a schema and a query, and ReifyDB keeps them up to date.

Create a 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

The view schema declares the output shape. The AS block defines the query that produces it. When source data changes, the view updates incrementally.

Query a View

CREATE NAMESPACE vw_q;
CREATE TABLE vw_q::products {
  id: int4,
  name: utf8,
  price: float4,
  in_stock: bool
};
CREATE DEFERRED VIEW vw_q::available {
  id: int4,
  name: utf8,
  price: float4
} AS {
  FROM vw_q::products
  FILTER in_stock == true
  MAP { id: id, name: name, price: price }
};
INSERT vw_q::products [
  { id: 1, name: 'Widget', price: 9.99, in_stock: true },
  { id: 2, name: 'Gadget', price: 24.99, in_stock: false },
  { id: 3, name: 'Gizmo', price: 14.99, in_stock: true }
];
FROM vw_q::available
SORT { price: desc }

Query a view just like a table. You can chain transforms like SORT, FILTER, and TAKE on view results.