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

Transactional Views

Transactional views are updated atomically within the same transaction as the source data. They are always consistent.

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

Use CREATE VIEW (without DEFERRED) to create a transactional view. The view updates atomically when its source tables change.