Tutorial: Building with CleaveDB

Real-time Pub/Sub (LISTEN) — Overview

Modern interactive applications—such as live collaborative editors, instant messaging, financial tickers, and multi-user dashboards—require immediate updates when data changes. Instead of maintaining external message brokers like Redis Pub/Sub or third-party web socket services, CleaveDB turns directly into a real-time event broker using LISTEN.

Three Subscription Models

Real-Time Architecture Highlights

• Direct In-Engine Dispatch: Mutation events are intercepted inside the query execution cycle, ensuring sub-millisecond broadcast latency.
• Connection-Level DLS Enforcement: Broadcasted events automatically honor Data-Level Security (DLS) policies matching the connected client's authenticated role.
• Multi-Client Scaling: Lightweight asynchronous event dispatchers support thousands of concurrent connected subscribers without database performance degradation.

Explore the Real-Time Topics

Review the guides below to build reactive real-time architectures:

• Subscribe to a bucket: listen to all insertions and modifications within a target collection.
• Subscribe to a document: pinpoint subscriptions to monitor an individual entity's state transitions.
• Live computed feeds: stream dynamically transformed records combining ENRICH and LISTEN.