Results of 1 - 8 of about 8 for servers (0.002 sec.)
- Backup Extension Repositories 12399
- The core and community extension repositories have backup servers (see duckdb-backup.org ): Repository Primary server Backup server core http://extensions.duckdb.org http://extensions.duckdb-backup.org community http://community-extensions.
...duckdb.org http://community-extensions.duckdb-backup.org The backup servers serve byte-identical binaries, so signature checks are unaffected. Automatic Fallback Fallback is automatic: if the primar... - https://man.mtool.work/duckdb/2.0/operations_manual/backup_extension_repositorie...
- CONNECT and DISCONNECT Statements 11224
- New Support for the CONNECT and DISCONNECT statements was introduced in DuckDB 2.0. The CONNECT statement routes the current session to a remote database, so that subsequent queries execute on that remote and their results stream back. DISC
...ection returns an error. Supported Databases CONNECT works with databases that support remote execution, including: DuckDB servers reached over the Quack protocol . PostgreSQL and MySQL servers. For these, the remote pushdown optimizer ships SQL directl... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- Reference 9561
- 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
...uack_serve parameters below. quack_stop(listen_uri) Stop the server listening on listen_uri . quack_server_list() List the servers running in this instance: listen URI and URL, host, port, number of active connections, and additional info (IPv6, SSL). q...uack_active_connections() List the client connections of the servers running in this instance: server, quack_connection_id , last query, state, hashed client id, cached rows, and query start...ven and no default quack secret exists, store the generated token in a persistent default quack secret, so that subsequent servers reuse it. disable_ssl BOOLEAN true for local, else false Serve plain HTTP. Local URIs default to plain HTTP, other URIs to... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Quack Remote Protocol 8621
- 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
..._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, using a self-signed certificate unless you pass ssl_cert_file and ssl_key_file (see the Reference...com', 'SELECT 42', token = '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩', disable_ssl = true ); The query executes remotely and the server streams the result back. Errors occurring on the server (parse errors, missing tables, etc.) are shown locally in the DuckD...uack node exposes a whoami() table macro that surfaces basic identity and runtime info, useful when proxying to a fleet of servers or when correlating logs: {:.codebox-client} FROM remote_db.query('FROM whoami()'); ┌─────────┬──────────┬──────────┬─────... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- S3 API Support 8368
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...CS USE_SSL Whether to use HTTPS or HTTP S3 , GCS , R2 BOOLEAN true VERIFY_SSL Whether to verify the SSL certificate of the server S3 , GCS , R2 BOOLEAN true ACCOUNT_ID The R2 account ID to use for generating the endpoint URL R2 STRING - KMS_KEY_ID AWS K...MS (Key Management Service) key for Server Side Encryption S3 S3 STRING - REQUESTER_PAYS Allows use of "requester pays" S3 buckets S3 BOOLEAN false REFRESH Set to aut...e ): SET httpfs_enable_credential_refresh = false; Platform-Specific Secret Types S3 Secrets The httpfs extension supports Server Side Encryption via the AWS Key Management Service (KMS) on S3 using the KMS_KEY_ID option: CREATE OR REPLACE SECRET secret... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- DuckDB Wasm Client 7663
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...menting SQL type logic in JavaScript. DuckDB-Wasm is built on a virtual filesystem that treats local files, remote HTTP(S) servers and in-memory buffers uniformly. Because DuckDB understands file formats such as Parquet, it reads only the bytes a query... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
- Extension Distribution 7663
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...ructure is described in the “Downloading Extensions Directly from S3” section , and is the same for local paths and remote servers, for example: base_repository_path_or_url └── v1.0.0 └── osx_arm64 ├── autocomplete.duckdb_extension ├── httpfs.duckdb_ext... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Configuration 6723
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...control the size of the asynchronous thread pool and the read-ahead budget used when reading from object storage and HTTP servers. They are listed in the reference below and documented in more detail on the I/O page , together with the related http_cli...BOOLEAN true enable_optimizer Whether the query optimizer is enabled. BOOLEAN true enable_server_cert_verification Enable server side certificate verification. BOOLEAN false enable_view_dependencies Enable created VIEWs to create dependencies on the re...will be removed in a future release. Name Description Type Default value Scope enable_curl_server_cert_verification Enable server side certificate verification for CURL backend. BOOLEAN true GLOBAL enable_object_cache Deprecated legacy setting, does not... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work