1-- Get real-time updates for changes in a table (e.g., for a dashboard or live feed):
2LIVE SELECT * FROM message;
3
4-- With filtering
5LIVE SELECT * FROM message WHERE status = 'error';
6
7-- In your client, you'll receive notifications whenever records are created, updated, or deleted in the message table matching the query.

1-- Notify an external service
2DEFINE FUNCTION fn::notify_admin($record: any) {
3	RETURN http::post("https://example.com/api/notify", $record);
4};
5
6-- Subscribe to events and forward notifications
7DEFINE EVENT notify_new_person ON TABLE person
8	WHEN $event = "CREATE"
9	THEN {
10		LET $record = $after;
11		SELECT fn::notify_admin($record);
12	};

1-- Insert a time-stamped reading
2CREATE sensor_readings:[location:MainHall, sensor:Temp01, time::now()] CONTENT {
3	temperature_celsius: 22.5
4};
5
6-- Pre-computed view for daily averages
7DEFINE TABLE daily_readings AS
8	SELECT id[0] AS location,
9		time::day(id[2]) AS day,
10		math::mean(temperature_celsius) AS avg_temp
11	FROM sensor_readings
12	GROUP BY id[0], time::day(id[2]);
13
14-- Live query the daily view for real-time dashboarding
15LIVE SELECT * FROM daily_readings;

1# Detect specific events and broadcast an alert
2DEFINE EVENT high_temp_alert ON TABLE sensor_readings
3	WHEN $event = "CREATE" AND $after.temperature_celsius > 30
4	THEN {
5		RETURN http::post("https://example.com/api/alert", {
6			sensor: $after.id[1],
7			value: $after.temperature_celsius
8		});
9	};