Tutorial: Building with CleaveDB

Computed Fields (ENRICH) — Overview

In traditional database design, derived values (such as full names, sales tax, profit margins, or age classifications) create an architectural dilemma: either waste disk space storing redundant denormalized fields, or duplicate calculation logic across every web and mobile client application. CleaveDB solves this with Computed Virtual Fields (ENRICH).

The Three Pillars of ENRICH

Key Benefits

• Single Source of Calculation: Define business logic (e.g. tax formula or discount rate) once in the database rather than across multiple client apps.
• First-Class Queryability: Filter directly using computed fields in WHERE clauses (e.g. WHERE is_adult = true).
• Streaming Integration: Out-of-the-box support for WebSocket broadcasts—live subscribers receive pre-calculated values instantly.

Explore Computed Field Topics

Step through the lessons below to master virtual field declarations in CleaveQL:

• Virtual fields: declare dynamic fields using ENRICH and query them transparently.
• Expressions & formulas: utilize CONCAT, arithmetic operations, and boolean logic.
• Enrichment with masking: combine virtual attributes with dynamic Data-Level Security (DLS).