Results of 1 - 10 of about 26 for Protocol (0.001 sec.)
- Quack Extension 14349
- The quack extension adds support for the Quack remote protocol. Usage New DuckDB 2.0.0 shipped a polished version of the Quack protocol that is faster and more stable. Expect further improvements in upcoming patch releases. Quack is transpa
..., run: INSTALL quack; If you would like to load Quack explicitly, run: LOAD quack; For usage details, see the Quack remote protocol page .... - https://man.mtool.work/duckdb/2.0/core_extensions/quack.html
- File Access with the file: Protocol 11373
- DuckDB supports using the file: protocol. It currently supports the following formats: file:/some/path (host omitted completely) file:///some/path (empty host) file://localhost/some/path ( localhost as host) Note that the following formats
...hey are non-standard: file:some/relative/path (relative path) file://some/path (double-slash path) Additionally, the file: protocol currently does not support remote (non-localhost) hosts.... - https://man.mtool.work/duckdb/2.0/guides/file_formats/file_access.html
- PostgreSQL Extension and the Secret Manager 10050
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...SLCOMPRESSION SSLCERT SSLKEY SSLKEYLOGFILE SSLPASSWORD SSLCERTMODE SSLROOTCERT SSLCRL SSLCRLDIR SSLSNI REQUIREPEER SSL_MIN_PROTOCOL_VERSION SSL_MAX_PROTOCOL_VERSION MIN_PROTOCOL_VERSION MAX_PROTOCOL_VERSION KRBSRVNAME GSSLIB GSSDELEGATION SCRAM_CLIENT_KE... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- CONNECT and DISCONNECT Statements 9555
- 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
...work, and any other DuckDB can attach to it and route queries there. Examples Attach a remote DuckDB server over the Quack protocol , route queries to it, and disconnect again: ATTACH 'quack:server.example.com' AS qk (TOKEN '⟨my_token⟩'); CONNECT qk; SEL...ted 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 directly to the server instead of pulli... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- Quack Setup 9389
- This section contains setup guides for using the Quack Remote Protocol .
... - https://man.mtool.work/duckdb/2.0/quack/setup/overview.html
- Documentation 9059
- Connecting to DuckDB DuckDB connection overview Quack remote protocol Client APIs C C++ CLI (command line interface) Go Java (JDBC) Node.js ODBC Python R Rust WebAssembly All client APIs SQL Introduction Statements Other Guides Installation
... - https://man.mtool.work/duckdb/2.0/
- Delta Extension 8728
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
..., 'delta.appendOnly' = 'true'); Properties that enable a Delta feature, such as deletion vectors, also upgrade the table's protocol as needed. Values can be any constant expression except NULL . Some properties cannot be set at creation, such as 'delta.e...s() shows the same pairs in its tags column. Column Mapping Delta tables with column mapping enabled are read as the Delta protocol specifies for each mode: in id mode, columns are matched by Parquet field ID; in name mode, by physical column name. The p...When writing, DuckDB shreds VARIANT values only if the table sets 'delta.enableVariantShredding' to 'true' , as the Delta protocol requires; otherwise it writes them unshredded. Because CREATE TABLE cannot set this property, a table created by DuckDB ho... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Quack Remote Protocol 8728
- 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
...S and authentication / authorization, see Security . For user guides, see Guides . Quack in a Nutshell In short, the Quack protocol and its interactions work as follows: HTTP-based. Quack messages travel over plain HTTP or HTTPS via a reverse proxy (see...session. Everything that the session can see (in-memory 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 optiona... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- What's New in the Docs for 2.0 8397
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...ce v1.5.3, DuckDB can run as a server via the Quack protocol, letting multiple clients connect to a shared instance over the network. DuckDB 2.0 ships a polished version of the quack...extension, which provides the remote protocol, and adds the new CONNECT and DISCONNECT statements to open and close connections from SQL. The command line client can st... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- DuckDB Repositories 8232
- 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 (
... - https://man.mtool.work/duckdb/2.0/dev/repositories.html
DuckDB 2.0 Documentation / man.mtool.work