⌘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 11 for threaded (0.002 sec.)
Instantiate 11807
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 ... that are not signed (see Load Extensions ). maximumThreads : the number of threads to use. This takes effect only with the threaded coi bundle on a cross-origin-isolated page (see Threading ). query : controls how query results are converted from Arrow i ... n milliseconds, at which streaming queries poll for results. Threading By default DuckDB-Wasm runs on a single thread. The threaded coi bundle runs queries across multiple threads, but it has two requirements: the page must be cross-origin isolated , and ... requirements are not met, the same code runs everywhere: on a page that is not cross-origin isolated it simply runs single-threaded, and bundle.pthreadWorker is null . Two things to keep in mind when deploying the threaded bundle: The page must be served ...
https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
Deploy 11042
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 ... For further details, see below. JS Worker Component. Compiled to JavaScript code, possibly instantiated multiple times for threaded environments. For further details, see below. Wasm Worker Component. Compiled as a WebAssembly file and instantiated by th ... elies on SharedArrayBuffer . Browsers only expose SharedArrayBuffer to pages that are cross-origin isolated . To serve the threaded bundle, the top-level document must be delivered with the following HTTP headers: Cross-Origin-Embedder-Policy: require-co ... o be embedded under these policies, most deployments run on non-isolated pages, where DuckDB-Wasm falls back to the single-threaded mvp or eh bundle. For more background on why these headers are required and how they unlock SharedArrayBuffer , see the fo ...
https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
Non-Deterministic Behavior 10793
Several operators in DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi- ... oint Aggregate Operations with Multi-Threading Floating-point inaccuracies may produce different results when run in multi-threaded configurations: For example, stddev and corr may produce non-deterministic results : CREATE TABLE tbl AS SELECT 'ABCDEFG'[ ...
https://man.mtool.work/duckdb/2.0/operations_manual/non-deterministic_behavior.h...
Troubleshoot 10028
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 R ... WebAssembly client uses a single thread; multithreading is available through the coi bundle but is still experimental. The threaded bundle relies on SharedArrayBuffer , which browsers only expose to pages that are cross-origin isolated . If the top-level ... served with the Cross-Origin-Embedder-Policy and Cross-Origin-Opener-Policy headers, DuckDB-Wasm falls back to the single-threaded mvp or eh bundle. See Cross-Origin Isolation for the required headers, and Threading for how to select and configure the c ...
https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
ODBC Extension 10028
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 ... the prepared statement and will be freed when the statement is destroyed. Connections and Concurrency DuckDB uses a multi-threaded execution engine to run parts of the query in parallel. ODBC drivers may or may not support using the same connection from ... ' col1 FROM DUAL') UNION ALL FROM odbc_query(getvariable('conn2'), 'SELECT ''bar'' col1 FROM DUAL'); Or by disabling multi-threaded execution setting threads DuckDB option to 1 . Transaction Management According to ODBC specification, connections to remo ... per-row and performs UCS-2 to UTF-8 conversion for every VARCHAR value. Besides that, query processing is strictly single-threaded. When submitting issues related only to performance please check the performance in comparable scenarios, for example with ...
https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
Julia Client 7752
The DuckDB Julia package provides a high-performance front-end for DuckDB. Much like SQLite, DuckDB runs in-process within the Julia client, and provides a DBInterface front-end. The package also supports multi-threaded execution. It uses J ...
https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/julia.html
Migrating Python Code to DuckDB 2.0 7503
This page lists what Python code written for DuckDB 1.x must change to run on DuckDB 2.0. Each item gives the 1.x form, the 2.0 form and the page that explains it. For changes outside the Python client, see Migrating to DuckDB v2.0 . Python ... version. DuckDB 2.0 requires Python 3.11 or newer; free-threaded builds of CPython are not supported. On Python 3.10, pip install duckdb installs a 1.x release. See Installation . Arrow a ...
https://man.mtool.work/duckdb/2.0/clients/python/migration.html
Python 7503
The DuckDB Python package has its own repository at duckdb/duckdb-python and uses nanobind 3 to create Python bindings with DuckDB. Prerequisites This guide assumes: You have a full clone of the DuckDB Python package source, including its g ... all uv version >= 0.8.0. Development Environment Setup 1. Platform-Specific Setup All Platforms Python 3.11 or later; free-threaded builds of CPython are not supported uv >= 0.8.0 required CMake, Ninja, nanobind and the NumPy headers (installed via UV) C ...
https://man.mtool.work/duckdb/2.0/dev/building/python.html
Samples 7503
Samples are used to randomly select a subset of a dataset. Examples Select a sample of exactly 5 rows from tbl using reservoir sampling: SELECT * FROM tbl USING SAMPLE 5; Select a sample of approximately 10% of the table using system sampli ... G SAMPLE 20% (system, 377) . As noted above, fixing the seed only guarantees a reproducible sample when DuckDB runs single-threaded ( SET threads = 1 ). With multiple threads, samples are not necessarily consistent even with a fixed seed. Sampling Method ...
https://man.mtool.work/duckdb/2.0/sql/samples.html
Python API 7254
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 ... ckDB using conda : conda install python-duckdb -c conda-forge . Python version: DuckDB requires Python 3.11 or newer. Free-threaded builds of CPython are not supported. If you are upgrading from DuckDB 1.x, see Migrating Python Code to DuckDB 2.0 . Basic ...
https://man.mtool.work/duckdb/2.0/clients/python/overview.html
PREV 1 2 NEXT
DuckDB 2.0 Documentation / man.mtool.work