Results of 1 - 3 of about 3 for codebox (0.001 sec.)
- Quack Remote Protocol 11868
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...mory tables, attached files, schemas) becomes reachable over the remote protocol. To start listening on localhost, run: {:.codebox-server} CALL quack_serve('quack:localhost'); The URI argument is optional: calling quack_serve() without it also listens o...e, the auth_token that clients need to connect. To choose the token yourself, pass the token parameter (see Security ): {:.codebox-server} CALL quack_serve('quack:localhost', token = '⟨my_token⟩'); Tip The DuckDB CLI can start a server directly with the...anything other than a local hostname. To listen on an externally-reachable address, pass allow_other_hostname = true : {:.codebox-server} CALL quack_serve('quack:0.0.0.0:9494', allow_other_hostname = true); Non-local servers serve HTTPS by default, usi... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Securing Quack with a Reverse Proxy 8501
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...tart Quack and Connect Through the Proxy In one DuckDB session, start the server (this prints an authentication token): {:.codebox-server} CALL quack_serve('quack:localhost'); In the client session, connect through Caddy on :8443 . Local URIs default to...plain HTTP, so you have to force SSL on explicitly: {:.codebox-client} ATTACH 'quack:localhost:8443' AS quack ( TOKEN '⟨authentication_token-from-quack_serve⟩', DISABLE_SSL false ); FRO...ing and inflates memory. proxy_buffering off; } } On the Quack side, start the server bound to localhost (the default): {:.codebox-server} CALL quack_serve('quack:localhost'); Issue the certificate with certbot --nginx -d quack.example.com . Clients con... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Troubleshooting Quack 7515
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...UTION 'eager' so that schemas are resolved while tables are enumerated, which lets Quack import their real definitions: {:.codebox-server} -- Server: substitute your own warehouse, URI, and secret. LOAD iceberg; LOAD quack; ATTACH 'warehouse' AS ice ( T...T 42 AS i; CALL quack_serve('quack:localhost', token = 'example-token'); The client can then attach and query as usual: {:.codebox-client} -- Client, in a separate DuckDB instance. LOAD quack; ATTACH 'quack:localhost' AS remote (TOKEN 'example-token');...want to keep lazy resolution, use quack_query() , which runs SQL directly on the server without importing its catalog: {:.codebox-client} FROM quack_query( 'quack:localhost', 'SELECT count(*) FROM ice.demo.orders', token = 'example-token' );... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work