⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 10 of about 13 for Worker (0.002 sec.)
Instantiate 13478
Overview DuckDB-Wasm can be instantiated in several ways, depending on how your application bundles and serves its assets. Each approach resolves the mainModule (the WebAssembly file) and the mainWorker (the worker script) for the browser's ... s() returns the set of bundles hosted on jsDelivr , and selectBundle picks the one that matches the browser. Because a Web Worker script must be same-origin, the CDN worker URL is wrapped in a Blob that importScripts it, and the temporary object URL is ... revoked once the worker has started. import * as duckdb from '@duckdb/duckdb-wasm'; const JSDELIVR_BUNDLES = duckdb.getJsDelivrBundles(); // Selec ... t a bundle based on browser checks const bundle = await duckdb.selectBundle(JSDELIVR_BUNDLES); const worker_url = URL.createObjectURL( new Blob([`importScripts("${bundle.mainWorker}");`], {type: 'text/javascript'}) ); // Instantia ...
https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
Deploy 11366
Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a ... nts: Main Library Component. Distributed as TypeScript and compiled to JavaScript code. For further details, see below. JS Worker Component. Compiled to JavaScript code, possibly instantiated multiple times for threaded environments. For further detail ... s, see below. Wasm Worker Component. Compiled as a WebAssembly file and instantiated by the browser. For further details, see below. DuckDB Extensio ... r It cannot be served as-is: it requires transpilation, because it needs to know the location of the follow-up files — the worker and WebAssembly components — in order to work. The exact steps depend on your setup; see the examples in the repository . ...
https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
DuckDB Wasm Client 10187
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 ... / Instantiate DuckDB-Wasm from a jsDelivr bundle const bundle = await duckdb.selectBundle(duckdb.getJsDelivrBundles()); // Worker scripts must be same-origin, so wrap the CDN worker in a Blob URL const worker_url = URL.createObjectURL( new Blob([`impor ... tScripts("${bundle.mainWorker}");`], { type: 'text/javascript' }) ); const worker = new Worker(worker_url); const db = new duckdb.AsyncDuckDB(new duckdb ... .ConsoleLogger(), worker); await db.instantiate(bundle.mainModule, bundle.pthreadWorker); URL.revokeObjectURL(worker_url); // Open a connection and ...
https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
I/O 9132
Warning DuckDB ships with safe defaults. The configuration options described on this page are advanced options, so proceed with caution when changing them. Asynchronous I/O New Asynchronous I/O was introduced in DuckDB 2.0. Starting with v2 ... .0, DuckDB supports asynchronous I/O. Instead of blocking a worker thread until requested data arrives, DuckDB issues reads in the background and keeps multiple requests in flight while wor ... read through data lake formats such as DuckLake . Thread Pools DuckDB uses two thread pools: The regular pool contains the worker threads, which perform the actual query processing (e.g., decoding, joins and aggregations). Its size is controlled by the ... : it schedules the reads for upcoming scan jobs (e.g., row groups in Parquet files or byte ranges in CSV files) before the worker threads need them. While a worker thread processes the current job, the asynchronous threads fetch the data for the next j ...
https://man.mtool.work/duckdb/2.0/data/io.html
PostgreSQL Extension Connection Pool 8269
PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive ... a single PostgreSQL table. The number of parallel queries running for a single table scan can be as high as the number of worker threads of the current DB instance ( threads global configuration option). When the threads parameter is set too high (tha ... ceeded) - then that worked thread does not participate futher in the processing of this table scan, that proceeds with the worker threads that were able to acquire a connection from the pool. See the description of the postgres_configure_pool function ... ned to the pool. Thread-local Cache Idle connection in a pool are available for any caller thread, be it a DuckDB internal worker thread or a new client thread. In some cases it may be beneficial to ensure, that subsequent queries from the same thread ...
https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
Connect 8023
Overview Every DuckDB feature reachable from Rust starts with a Connection . Opening in-memory and file-backed databases, configuring a database instance with Config , opening read-only, pooling connections across threads, the crate's threa ... documentation for how connections and threads interact. Connection Pooling For applications that hand a connection to each worker thread, the r2d2 feature integrates DuckDB with the r2d2 connection pool. A DuckdbConnectionManager creates connections th ... anager}; let manager = DuckdbConnectionManager::file("my_database.duckdb")?; let pool = r2d2::Pool::new(manager)?; // Each worker checks out its own connection from the pool. let conn = pool.get()?; conn.execute("INSERT INTO foo (bar) VALUES (?)", para ...
https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
PostgreSQL Extension Functions 7918
postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name ... e - so no connection was provided by the pool; note that when the parallel scans are performed by the Postgres extension - worker threads always use the try acquire mode; when SET threads = ⟨number_higher_then_pool_size⟩ is used, then some of the worke ...
https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
Troubleshooting 7742
Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬───────────────────── ... d this, it's recommended to import numpy.core.multiarray before starting up threads. Many Threads per Database Besides its worker threads, each database starts a pool of asynchronous I/O threads : by default four times the number of CPU cores, at most ...
https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
Python API 7671
Installation To use the DuckDB Python client, visit the Python installation page . The latest stable version of the DuckDB Python client is 2.0.0. Installation The DuckDB Python API can be installed using pip : pip install duckdb . Please s ... configuration options can be specified. For example: import duckdb con = duckdb.connect(config={"threads": 1}) Besides its worker threads, each database starts a pool of asynchronous I/O threads : by default four times the number of CPU cores, at most ...
https://man.mtool.work/duckdb/2.0/clients/python/overview.html
Quack Remote Protocol 7671
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 ... r: {:.codebox-client} CALL quack_identify( name = 'analytics-1', provider = 'ec2', region = 'eu-west-1', meta = '{"role": "worker"}' ); meta is merged with auto-computed duckdb_version and platform keys; user-supplied keys win on conflict. whoami_start ...
https://man.mtool.work/duckdb/2.0/quack/overview.html
PREV 1 2 NEXT
DuckDB 2.0 Documentation / man.mtool.work