Results of 1 - 10 of about 113 for client (0.005 sec.)
- DuckDB Repositories 11124
- Several components of DuckDB are maintained in separate repositories. Main Repositories duckdb : core DuckDB project duckdb-web : documentation and blog duckdb-quack : Quack remote protocol Clients duckdb-go : Go client duckdb-java : Java (
...JDBC) client duckdb-node-neo : Node.js client duckdb-odbc : ODBC client duckdb-pyodide : Pyodide client duckdb-python : Python client d...uckdb-r : R client duckdb-rs : Rust client duckdb-swift : Swift client duckdb-wasm : WebAssembly client duckplyr : a drop-in replacement for...dplyr in R DuckDB.jl : Julia client Connectors dbt-duckdb : dbt duckdb-mysql : MySQL connector duckdb-postgres : PostgreSQL connector (connect to PostgreSQL f... - https://man.mtool.work/duckdb/2.0/dev/repositories.html
- Reference 10985
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...RI and URL, host, port, number of active connections, and additional info (IPv6, SSL). quack_active_connections() List the client connections of the servers running in this instance: server, quack_connection_id , last query, state, hashed client id, ca...stname BOOLEAN false Allow binding to a non-local hostname, e.g., 0.0.0.0 . token VARCHAR (generated) Authentication token clients have to present (minimum 4 characters). If omitted, the token of the default quack secret is used if one exists, otherwis...ate is generated (see quack_generate_keys ). ssl_key_file VARCHAR (generated) Private key file used when serving over SSL. Client Queries Function Description quack_query(uri, query, ...) Run query on remote uri , stream result back. Accepts the named... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Startup & Shutdown 10859
- To use DuckDB, you must first initialize a duckdb_database handle using duckdb_open() . duckdb_open() takes as parameter the database file to read and write from. The special value NULL ( nullptr ) can be used to create an in-memory databas
...ss ( duckdb_connection connection ); void duckdb_disconnect ( duckdb_connection * connection ); void duckdb_connection_get_client_context ( duckdb_connection connection , duckdb_client_context * out_context ); void duckdb_connection_get_arrow_options (...duckdb_connection connection , duckdb_arrow_options * out_arrow_options ); idx_t duckdb_client_context_get_connection_id ( duckdb_client_context context ); void duckdb_destroy_client_context ( duckdb_client_context *...bool qualified ); duckdb_create_instance_cache Creates a new database instance cache. The instance cache is necessary if a client/program (re)opens multiple databases to the same file within the same process. Must be destroyed with 'duckdb_destroy_inst... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Security 10809
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...ships with conservative defaults that prevent accidental exposure: The server requires an authentication token , which the client has to supply on every connection. Unless a token is passed explicitly or supplied by a quack secret, the server generates...he internet. We recommend you to put a proven HTTP reverse proxy in front of it and let the proxy terminate TLS. The Quack client is shipped with these assumptions in mind: for non-local URIs it assumes HTTPS by default, so a properly fronted server "j...ust works" from the client side too. See Securing Quack with a Reverse Proxy for nginx and Caddy recipes (production and local-test). Authentication... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Quack Remote Protocol 10140
- 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
...roxies handle Quack traffic the same way they handle any other HTTP service. There is no custom wire transport to operate. Client-driven request and response. Every interaction is initiated by the client. The server does not initiate interactions via p...k_serve returns the listen URI, the HTTP URL, and, when the default authentication function is in use, the auth_token that clients need to connect. To choose the token yourself, pass the token parameter (see Security ): {:.codebox-server} CALL quack_se...uri, ssl) scalar function. Stopping a Server To stop a server, run: {:.codebox-server} CALL quack_stop('quack:localhost'); Client-Side Usage There are three ways to talk to a Quack server: ATTACH 'quack:host' AS name followed by CONNECT name : route th... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Embedding DuckDB 9472
- CLI Client The Command Line Interface (CLI) client is intended for interactive use cases and not for embedding. As a result, it has more features that could be abused by a malicious actor. For example, the CLI client has the .sh feature tha
...t allows executing arbitrary shell commands. This feature is only present in the CLI client and not in any other DuckDB clients. .sh ls Tip Calling DuckDB's CLI client via shell commands is not recommended for embe...dding DuckDB. It is recommended to use one of the client libraries, e.g., Python , R , Java , etc.... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/embedding_du...
- Linux 8589
- Prerequisites On Linux, install the required packages with the package manager of your distribution. Ubuntu and Debian CLI Client On Ubuntu and Debian (and also MX Linux, Linux Mint, etc.), the requirements for building the DuckDB CLI client
...ev libcurl4-openssl-dev git clone https://github.com/duckdb/duckdb cd duckdb GEN=ninja make Fedora, CentOS and Red Hat CLI Client The requirements for building the DuckDB CLI client on Fedora, CentOS, Red Hat, AlmaLinux, Rocky Linux, etc. are the follo...ch Linux The following instructions are intended for Arch Linux and Arch-based distributions (e.g., Manjaro, Omarchy). CLI Client DuckDB is available in Arch's Extra package repository . To install it, run: sudo pacman -S duckdb The requirements for bu...ilding the DuckDB CLI client on Arch, Manjaro, etc. are the following: sudo pacman -S git gcc cmake ninja openssl git clone https://github.com/duckdb/d... - https://man.mtool.work/duckdb/2.0/dev/building/linux.html
- Troubleshooting Quack 8135
- 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
...he quack extension: FORCE INSTALL quack; ATTACH Fails to Bind a Remote Table Definition When a Quack client runs ATTACH 'quack:⟨host⟩' , it loads the server's table definitions up front and binds them locally. A single definition...default TABLE_RESOLUTION 'lazy' . Lazily resolved tables are listed with a placeholder column of type UNKNOWN , which the client receives through duckdb_tables() and cannot bind: Catalog Error: Type with name UNKNOWN does not exist! The UNKNOWN type h...ere is not the table's real type, and it does not mean the client must install the iceberg extension. It means the server has not yet resolved the table's schema. Resolving Tables Eagerly... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- Go Client 8097
- The latest stable release of the DuckDB Go client bundles DuckDB 2.0.0. Its own version tag encodes that DuckDB version; see Versioning below. The DuckDB Go client, duckdb-go , is a SQL driver that conforms to Go's built-in database/sql int
...erface, so DuckDB is used through the same API as any other Go SQL database. On top of database/sql , the client adds DuckDB-specific interfaces for the Appender , Apache Arrow , user-defined functions , and profiling . This page focus...tions on the database/sql interface, see the official documentation and the Go database access tutorial . Installation The client is a Go module. Add it to a project with go get , using the /v2 major-version suffix: go get github.com/duckdb/duckdb-go/v...y, including the pre-built DuckDB libraries from duckdb-go-bindings , run go mod vendor . DuckDB is written in C++, so the client uses cgo and requires a C compiler to build. By default it statically links a pre-built DuckDB library into the binary, so... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- Securing Quack with a Reverse Proxy 8046
- 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
...e / application server: put a proven HTTP reverse proxy in front of it, and let the proxy terminate TLS. The Quack client cooperates with this: for non-local URIs it assumes HTTPS by default, so a properly fronted server “just works” from the c...tself a certificate for localhost from a local CA and installs the CA root into your system trust store, so DuckDB's HTTPS client trusts the cert without any extra config. 1. Run Caddy Save this Caddyfile : localhost:8443 { reverse_proxy 127.0.0.1:9494...on, 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: {:.cod... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
DuckDB 2.0 Documentation / man.mtool.work