DuckDB Extensions
Outbox functions in the Radio DuckDB extension
Function category
Outbox
4 functionsSend messages out, with built-in delivery tracking. Queue, inspect, retract, and garbage-collect — all from SQL.
Signature
radio_subscription_transmit_message_delete(col0: VARCHAR, col1: UBIGINT) → None
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
VARCHAR
|
Mode Positional | Description |
Argument
col1
|
Type
UBIGINT
|
Mode Positional | Description |
Description
Remove a queued outgoing message that hasn't yet been transmitted.
Related functions
Signature
radio_subscription_transmit_messages(col0: VARCHAR) → None
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
VARCHAR
|
Mode Positional | Description |
Description
Table view of pending and sent outgoing messages with delivery status — what's been transmitted, what's queued, what failed.
Related functions
Signature
radio_subscription_transmit_messages_delete_finished(col0: VARCHAR) → None
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
VARCHAR
|
Mode Positional | Description |
Description
Garbage-collect already-delivered outgoing messages from the transmit log.
Related functions
Signature
radio_transmit_message(
col0: VARCHAR,
col1: VARCHAR,
col2: BLOB,
col3: INTEGER,
col4: INTERVAL
) → None
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
VARCHAR
|
Mode Positional | Description |
Argument
col1
|
Type
VARCHAR
|
Mode Positional | Description |
Argument
col2
|
Type
BLOB
|
Mode Positional | Description |
Argument
col3
|
Type
INTEGER
|
Mode Positional | Description |
Argument
col4
|
Type
INTERVAL
|
Mode Positional | Description |
Description
Queue an outgoing message on a subscription. Returns once the message is buffered; delivery is tracked separately.