Results of 1 - 10 of about 56 for Remote (0.002 sec.)
- Quack Remote Protocol 14351
- 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
...DuckDB 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 i...hree ways to talk to a Quack server: ATTACH 'quack:host' AS name followed by CONNECT name : route the whole session to the remote . This is the recommended approach. ATTACH 'quack:host' AS name : attach the remote as a full catalog and query it by qual..., run: {:.codebox-client} FROM quack_query( 'quack:localhost', 'SELECT 42', token = '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩'); Remote databases use HTTPS by default. To override on a plain-HTTP remote, run: {:.codebox-client} FROM quack_query( 'quack:remot... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- CONNECT and DISCONNECT Statements 11330
- 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
...can serve its databases over the network, 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...CONNECT qk; SELECT count(*) FROM events; -- executes on the server, results stream back DISCONNECT; Connect directly to a remote database using a connection string. For databases other than DuckDB, the connection string must start with the type of the...string⟩' }; DISCONNECT; CONNECT accepts either the alias of a database attached with ATTACH , or a connection string for a remote database. While a connection is active, queries that do not explicitly qualify a different database execute on the remote.... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- Import Data 10328
- Overview DuckDB-Wasm has multiple ways to import data, depending on the format of the data. Importing happens in two steps. The data file is registered in a virtual file system using one of the register functions ( registerFileBuffer , regi
...on a connection ( conn ). Alternatively, the Parquet, JSON, or Wasm-flavored httpfs extensions can read a registered — or remote — file directly from a FROM SQL query, and INSERT statements can load values inline. The examples below all use a connecti...gh a dedicated insert function, then read with SQL. Register a local file picked by the user with registerFileHandle() , a remote file with registerFileURL() , or bytes you have already fetched with registerFileBuffer() : // Local file chosen by the us...tUserPickFile(); await db.registerFileHandle('local.parquet', pickedFile, DuckDBDataProtocol.BROWSER_FILEREADER, true); // Remote file, read lazily over HTTP await db.registerFileURL('remote.parquet', 'https://origin/remote.parquet', DuckDBDataProtocol... - https://man.mtool.work/duckdb/2.0/clients/wasm/data_ingestion.html
- ODBC Extension Functions 9739
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...ble('params1'), row(42, 'foo')) odbc_close odbc_close(conn_handle BIGINT) -> VARCHAR Closes specified ODBC connection to a remote DB. Does not throw errors if the connection is already closed. Parameters: conn_handle ( BIGINT ): ODBC connection handle...R) -> BIGINT odbc_connect(conn_string VARCHAR, username VARCHAR, password VARCHAR) -> BIGINT Opens an ODBC connection to a remote DB. If username and password (positional) parameters are specified, they are appended to the connection string as UID and...conn_string VARCHAR, [, <optional named parameters>]) -> TABLE Copies rows from a DuckDB accessible file or table into the remote DB. Warning Using odbc_copy from Python Relational API . odbc_copy is a table function that returns one row for each 2048... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Deploying Quack 9680
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...id I just launch? FROM quack_query('⟨uri⟩', 'FROM whoami()'); -- Anything else you'd normally run, shipped verbatim to the remote. FROM quack_query('⟨uri⟩', 'SELECT 1 + 1'); Sticky Session via ATTACH ATTACH keeps server-side state (temp tables, SET var...iables) across calls, which quack_query alone does not. ATTACH '⟨uri⟩' AS remote (TYPE quack); -- Temp table lives on the remote. FROM quack_query_by_name('remote', 'CREATE TEMP TABLE t AS SELECT range A...S x FROM range(10)'); FROM quack_query_by_name('remote', 'SELECT sum(x) FROM t'); -- Session settings stick. FROM quack_query_by_name('remote', 'SET threads = 8'); FROM quack_qu... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Share a DuckDB Database That Only Stores Views 9091
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...This only needs to be run once. Building the Catalog Create a persistent database file and define views that reference the remote data. Use fully qualified locations (remote URLs or absolute paths) so that the views resolve regardless of the client's w...catalog read-only and query the views as if they were local tables. Each query reads the current data from the referenced remote files: ATTACH 'https://example.com/catalog.duckdb' AS catalog (READ_ONLY); SELECT count(*) AS num_stations FROM catalog.st...modified in place. Query performance depends on the network and the layout of the referenced files . The tips for querying remote files apply.... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- UI Extension 8973
- The ui extension adds a user interface for your local DuckDB instance. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui(); Running either of these will open the UI in your default browser. The
...ort = 4213; The environment variable ui_local_port can also be used. The default port is 4213. (Why? 4 = D, 21 = U, 3 = C) Remote URL The local HTTP server fetches the files for the UI from a remote HTTP server so they can be kept up-to-date. The defau...lt URL for the remote server is https://ui.duckdb.org . An alternate remote URL can be configured with a SQL command like: SET ui_remote_url = '...https://ui.duckdb.org'; The environment variable ui_remote_url can also be used. This setting is available mainly for testing purposes. Be sure you trust any URL you configure, as t... - https://man.mtool.work/duckdb/2.0/core_extensions/ui.html
- ODBC Extension 8501
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
..., but needs to be loaded manually with: LOAD odbc; Usage Example -- load extension LOAD odbc; -- open ODBC connection to a remote DB SET VARIABLE conn = odbc_connect('Driver={Oracle driver};DBQ=//127.0.0.1:1521/XE', 'scott', 'tiger'); -- simple query F...nn'), 'SELECT CAST(? AS NVARCHAR2(2)) || CAST(? AS VARCHAR2(5)) FROM DUAL', params = row('?', 'quack')); -- copy data into remote DB FROM odbc_copy(getvariable('conn'), source_file = 'https://blobs.duckdb.org/nl_stations.csv', dest_table = 'NL_TRAIN_ST...put parameters from the client code. The extension allows to forward such input parameters over ODBC API to the queries to remote databases. Two methods of passing query parameters are supported, using either params or params_handle named argument to o... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Tuning Workloads 8442
- DuckDB aims to perform well out of the box, so most workloads do not require any tuning. When tuning is worthwhile, there is no single configuration or magic number that is optimal for every workload: the right settings depend on what you a
...nts Prepared statements Reading files over a slow or unreliable network Tuning asynchronous I/O and minimizing IO Querying remote files Running many small queries Reusing a single connection Best practices for using connections The rest of this page co...ickly execute many small queries concurrently. Rather, it is optimized for running larger, less frequent queries. Querying Remote Files Starting with version 2.0, DuckDB uses asynchronous I/O when reading Parquet files, uncompressed, seekable UTF-8 CSV...PU cores) can improve parallelism and performance. Avoid Reading Unnecessary Data The main bottleneck in workloads reading remote files is likely to be the IO. This means that minimizing the unnecessarily read data can be highly beneficial. Some basic... - https://man.mtool.work/duckdb/2.0/guides/performance/how_to_tune_workloads.html
- Troubleshoot 8383
- Overview This page collects common issues encountered when using DuckDB-Wasm, together with their workarounds. If you run into a problem that is not covered here, search the duckdb-wasm issue tracker on GitHub. Network Error When Querying Remote
...emote Files When DuckDB-Wasm reads a remote file — through the Wasm-flavored httpfs extension or registerFileURL — the browser issues the request, so it is subject to...wser, not DuckDB-Wasm, enforces CORS. Apply it where the data is hosted, then read the file as usual. Beyond CORS, reading remote files has several other known limitations: Because every request is upgraded to HTTPS, an http:// URL can be rewritten inc...⟩' , the GET requests for the extension files must be CORS enabled for the browser to allow the connection, exactly as for remote data files above. Extensions remain signed regardless of where they are served, so copying an extension to a different loc... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
DuckDB 2.0 Documentation / man.mtool.work