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

Scripting

ReifyDB's scripting language lets you define schemas, manipulate data, create views, procedures, events, tests, and more — all in a single coherent system.

Define Schema

Namespaces organize your tables. Every table lives inside a namespace.

Insert and Query

Insert rows, then query them with FROM. Everything is transactional.

Built-in Testing

CREATE NAMESPACE tg;
CREATE TABLE tg::items { id: int4, name: utf8 };
CREATE TEST PROCEDURE tg::seed AS {
  INSERT tg::items [{ id: 1, name: 'one' }, { id: 2, name: 'two' }]
};
CREATE TEST tg::query_all {
  CALL tg::seed();
  FROM tg::items | ASSERT { id > 0 }
};
CREATE TEST tg::filter_one {
  CALL tg::seed();
  FROM tg::items | FILTER name == 'one' | ASSERT { id == 1 }
};
RUN TESTS tg | MAP { name, namespace, outcome }

Write tests alongside your schema. Seed data with test procedures, assert results inline.

What's Covered

--Schema — Namespaces, tables, enums, dictionaries
--Storage Types — Ringbuffers, series, tags
--Data Manipulation — Insert, update, delete
--Views — Deferred and transactional materialized views
--Procedures — Reusable logic with parameters and control flow
--Events — Event-driven state transitions
--Testing — Built-in test framework
--Migrations — Schema versioning with rollback