Skip to content

Inbox functions in the Radio DuckDB extension

Function category

Inbox

3 functions

radio_received_messages

Table function Inbox
Signature
radio_received_messages() → None
Description
1 Recent text messages
SELECT receive_time, channel, decode(message) AS text FROM radio_received_messages() WHERE message_type = 'message' ORDER BY receive_time DESC LIMIT 100;
2 Messages injected into a loopback subscription (DuckDB 2.0)
SELECT channel, decode(message) AS text, seen_count FROM radio_received_messages();

radio_subscription_received_message_add

Table function Inbox
Signature
radio_subscription_received_message_add( url: VARCHAR, channel: VARCHAR, message: BLOB | VARCHAR ) → None
Arguments (Positional)
Argument url Type VARCHAR Mode Positional Description
Argument channel Type VARCHAR Mode Positional Description
Argument message Type BLOB | VARCHAR
2 concrete types
BLOBVARCHAR
Mode Positional Description
Description
1 Inject a test message (DuckDB 2.0: loopback transport)
SELECT * FROM radio_subscription_received_message_add('loopback://demo', 'news', 'héllo');

radio_subscription_received_messages

Table function Inbox
Signature
radio_subscription_received_messages(url: VARCHAR) → None
Arguments (Positional)
Argument url Type VARCHAR Mode Positional Description
Description
1 Messages from one feed
SELECT receive_time, decode(message) AS text FROM radio_subscription_received_messages('wss://stream.example.com/events') ORDER BY receive_time DESC;
2 Loopback subscription (DuckDB 2.0)
SELECT message_id, decode(message) AS text FROM radio_subscription_received_messages('loopback://demo');