Results of 1 - 10 of about 13 for convenient (0.002 sec.)
- Overview 13724
- We designed DuckDB to be easy to deploy and operate. We believe that most users do not need to consult the pages of the operations manual. However, there are certain setups – e.g., when DuckDB is running in mission-critical infrastructure –
...uld like to offer advice on how to configure DuckDB. The operations manual contains advice for these cases and also offers convenient configuration snippets such as Gitignore files. For advice on getting the best performance from DuckDB, see also the Perfo... - https://man.mtool.work/duckdb/2.0/operations_manual/overview.html
- Profile and Monitor 10135
- 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
...dle is both Send and Sync , so you can move it, or the connection, to another thread and call interrupt() from wherever is convenient. The interrupted query fails with an error: use duckdb::{Connection, Result}; fn run_query(conn: Connection) -> Result<()>... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- Instantiate 9624
- 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
...vaScript type mapping: castBigIntToDouble : return 64-bit integers as JavaScript numbers instead of BigInt values. This is convenient, but large integers can lose precision. castDecimalToDouble : return DECIMAL values as floating-point numbers instead of D...FROM 'opfs://data.parquet'`); await conn.query(`COPY (SELECT * FROM t) TO 'opfs://export.csv'`); Automatic registration is convenient for one-off reads. Manual registration requires more code but avoids re-acquiring an OPFS access handle on every statement... - https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
- Comparisons 9624
- Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than
...on on different types, DuckDB performs Combination Casting . These casts were introduced to make interactive querying more convenient and are in line with the casts performed by several programming languages but are often not compatible with PostgreSQL's b... - https://man.mtool.work/duckdb/2.0/sql/expressions/comparison_operators.html
- Avro Extension 9096
- The avro extension enables DuckDB to read Apache Avro files. The avro extension was released as a community extension in late 2024 and became a core extension in early 2025. The read_avro Function The extension adds a single DuckDB function
..." the Avro schema. Avro defines tables as root-level "record" fields, which are the same as DuckDB STRUCT fields. For more convenient handling, this extension turns the entries of a single top-level record into top-level columns. Implementation Internally,... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- Connect 8586
- 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
...tent database, flushes the write-ahead log to disk. Always close every object that has a Close() method, which defer makes convenient: db, _ := sql.Open("duckdb", "") defer db.Close() conn, _ := db.Conn(context.Background()) defer conn.Close() rows, _ := c... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Securing Extensions 8586
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...low_extension_repositories = 'forbidden'; Community Extensions DuckDB has a Community Extensions repository , which allows convenient installation of third-party extensions. Community extension repositories like pip or npm are essentially enabling remote c... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- Node.js Client (Neo) 8076
- Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi
...onnection.run(sql, values, types); // Run to completion but don't yet retrieve any rows. // Wrap in a DuckDBDataReader for convenient data retrieval. const reader = await connection.runAndRead(sql); const reader = await connection.runAndRead(sql, values);...tream(sql, values, types); // Create a streaming result and don't yet retrieve any rows. // Wrap in a DuckDBDataReader for convenient data retrieval. const reader = await connection.streamAndRead(sql); const reader = await connection.streamAndRead(sql, val... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- Create Synthetic Data 8076
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...s the stop value, while generate_series includes it. VALUES The VALUES clause generates rows from literal tuples, which is convenient for a small fixed set of values to draw from: SELECT * FROM (VALUES ('Alice', 'Engineering'), ('Bob', 'Sales')) t(name, de... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Struct Functions 8076
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...sed, not its value, so any value of the desired type works; a typed NULL literal (e.g. NULL::STRUCT(v1 INT, v2 INT) ) is a convenient way to declare the target shape when no suitable value is at hand. mapping is a STRUCT keyed by target field name whose va... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
DuckDB 2.0 Documentation / man.mtool.work