DuckDB extension · pure C
DuckDB, on the network.
ducknng turns a DuckDB session into an NNG service — and into an NNG client. Framed RPC with Arrow and Quack payloads, query sessions, mTLS and policy admission in C, and an HTTP carrier. Anything that speaks NNG, WebSocket, or HTTP can call it: nanonext from R, a browser, your own client in any language, or another DuckDB.
Get started Read the protocol GitHub
inproc:// ipc:// tcp://
tls+tcp:// ws:// wss://
http:// https://
Get started
Two DuckDB sessions, three steps, no broker in between.Load the extension
Build it first (see Development), then load the artifact into any DuckDB session.
LOAD 'build/release/ducknng.duckdb_extension';
Serve a session over TLS
Port 0 lets the OS assign a free port, and the self-signed certificate lives only in DuckDB memory — no files to manage.
SET VARIABLE tour_tls = ducknng_self_signed_tls_config('127.0.0.1', 365, 0);
SELECT ducknng_start_server(
'tour', -- service name
'tls+tcp://127.0.0.1:0', -- TLS; port 0 = OS-assigned
1, -- REP contexts
134217728, -- recv_max_bytes (128 MiB)
300000, -- session_idle_ms
getvariable('tour_tls')::UBIGINT -- TLS config handle
);
SELECT name, listen FROM ducknng_list_servers();
| name | listen |
|---|---|
| tour | tls+tcp://127.0.0.1:41573 |
Query it from another session
The URL scheme picks the carrier. The same call works over ipc://, tcp://, wss://, or https:// without changing the method contract.
SELECT *
FROM ducknng_query_rpc(
'ipc:///tmp/ducknng.ipc',
'SELECT i, i > 10 AS gt_10
FROM (VALUES (7), (11), (42)) t(i) ORDER BY i',
0::UBIGINT,
schema := NULL::STRUCT(i INTEGER, gt_10 BOOLEAN)
);
| i | gt_10 |
|---|---|
| 7 | false |
| 11 | true |
| 42 | true |
SELECT ok, type_name, name
FROM ducknng_decode_frame(
ducknng_request_raw(
getvariable('tour_url'),
from_hex('0100000000000000000000
00000000000000000000'),
1000, getvariable('tour_tls')::UBIGINT
)
);
| ok | type_name | name |
|---|---|---|
| true | result | manifest |
Run it in your browser
The same extension compiles to a duckdb-wasm side module. The demo loads it in your own tab, runs the smoke checks, and opens a SQL shell against that connection — no server, no install.
SELECT provider, media_types
FROM ducknng_list_codecs()
ORDER BY provider
LIMIT 3;
| provider | media_types |
|---|---|
| arrow | application/vnd.apache.arrow.stream |
| ducknng | application/vnd.ducknng.frame |
| json | application/json |