Results of 1 - 10 of about 20 for send (0.002 sec.)
- Run Queries 15124
- Overview DuckDB-Wasm provides functions for querying data. Queries are run sequentially: First, create a connection by calling connect . Then, run queries by calling query to materialize the whole result, or send to fetch result chunks lazi
...verting results to JSON, and exporting to Parquet. Query Execution Use query() when you want the entire result at once, or send() to iterate over Apache Arrow record batches as they are produced — useful for large results that you would rather stream...ECT * FROM generate_series(1, 100) t(v) `); // ..., or fetch the result chunks lazily for await (const batch of await conn.send<{ v: arrow.Int }>(` SELECT * FROM generate_series(1, 100) t(v) `)) { // ... } // Close the connection to release memory aw...epeatedly with different parameter values, binding each value in place of a ? placeholder. Both query() (materialized) and send() (streamed) are available on a prepared statement: // Create a new connection const conn = await db.connect(); // Prepare... - https://man.mtool.work/duckdb/2.0/clients/wasm/query.html
- Troubleshoot 10604
- 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
...the data must allow (using CORS headers) the origin that hosts the DuckDB-Wasm instance to read it. If the server does not send the required headers, the query fails with a network error such as: Failed to execute 'send' on 'XMLHttpRequest' For examp..., an http:// URL can be rewritten incorrectly (for example to https://http//… ), which breaks reads against local or non-TLS endpoints (see duckdb-wasm issue #2118 ). DuckDB relies on HTTP range requests to read only part of a file. Range requests ca...atasets can therefore run out of memory where native DuckDB would not. To stay within the limit: Stream large results with send() instead of materializing them all at once with query() . Read only the columns and rows you need. Because DuckDB reads P... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Run Queries 9193
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...nnection these run on, see Define Connections . Sending Queries DuckDB supports the standard JDBC methods to send queries and retrieve result sets. First a Statement object ha...s to be created from the Connection , this object can then be used to send queries using execute() and executeQuery() . execute() is meant for queries where no results are expected like CREATE TABL... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Connect 9040
- 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
...config)?; AccessMode has three variants: Automatic (the default), ReadOnly , and ReadWrite . Thread Safety A Connection is Send but not Sync : it can be moved to another thread, but it cannot be shared between threads at the same time. The recommende...serve and handle a shutdown error that Drop would otherwise discard. Further Reading Run Queries — using the Connection to send queries and read results. Configuration — the full list of DuckDB settings that can be passed to Config . Concurrency — ho... - https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
- Overview 8887
- Installation To use the DuckDB C API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C API is 2.0.0. DuckDB implements a custom C API modeled somewhat following the SQLite C API. The API is contain
...C API, never both. Before marking the C API v2 as stable, we would like to test it in the field. Please give it a try and send us your feedback ! Installation The DuckDB C API can be installed as part of the libduckdb packages. Please see the instal... - https://man.mtool.work/duckdb/2.0/clients/c/overview.html
- Profile and Monitor 8411
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...ed from another thread. Call interrupt_handle() on the connection to get an Arc<InterruptHandle> . InterruptHandle is both Send and Sync , so you can move it, or the connection, to another thread and call interrupt() from wherever is convenient. The... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- C++ API 7953
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...in a multithreaded environment. DuckDB db(nullptr); Connection con(db); Querying Connections expose the Query() method to send a SQL query string to DuckDB from C++. Query() runs the query to completion and returns a QueryResult that retains the res... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Connect 7953
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...ptly is essential to keep memory in check. Further Reading Run Queries — using the database and connections opened here to send queries and read results. Configuration — the full list of DuckDB settings that can be passed in the DSN or the connector... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Import Data 7953
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...rors raised during that implicit flush are discarded, because Rust's Drop cannot report them. The Appender is Sync but not Send , because it borrows the Connection . To append from another thread, move the Connection to that thread and create the app...DB can read many file formats directly in SQL, which is often the simplest way to load external data. The Rust client just sends the query. For Parquet , enable the parquet feature and query read_parquet() , adapted from the crate's parquet example :...bulk-loading options. Handle Results — the Apache Arrow integration used to append and read record batches. Run Queries — sending the CREATE TABLE and COPY statements the file readers build on.... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- DuckDB Wasm Client 7953
- 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
...run at near-native speed. This lets a full DuckDB engine run entirely inside any browser on any device, with no server to send queries to and no data leaving the user's machine. It offers a layered API to fit different needs: embedded as a JavaScrip... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
DuckDB 2.0 Documentation / man.mtool.work