Results of 1 - 10 of about 15 for configurations (0.001 sec.)
- ODBC Configuration 12870
- This page documents the files using the ODBC configuration, odbc.ini and odbcinst.ini . These are either placed in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific
...DuckDB] : between the brackets is a DSN for the DuckDB. Driver : Describes the driver's name, as well as where to find the configurations in the odbcinst.ini . Database : Describes the database name used by DuckDB, can also be a file path to a .db in the syste...mode : The mode in which to connect to the database. odbcinst.ini and .odbcinst.ini The odbcinst.ini file contains general configurations for the ODBC installed drivers in the system. A driver section starts with the driver name between brackets, and then it f...e [DuckDB Driver] Driver = /path/to/libduckdb_odbc.dylib The lines correspond to the following parameters: [ODBC] : The DM configuration section. Trace : Enables the ODBC trace file using the option yes . TraceFile : The absolute system file path for the ODBC... - https://man.mtool.work/duckdb/2.0/clients/odbc/configuration.html
- Performance Guide 11320
- DuckDB aims to automatically achieve high performance by using well-chosen default configurations and having a forgiving architecture. Of course, there are still opportunities for tuning the system for specific workloads. The Performance Gu
... - https://man.mtool.work/duckdb/2.0/guides/performance/overview.html
- macOS 10693
- Prerequisites Install Xcode and Homebrew . Then, install the required packages with: brew install git cmake ninja Building DuckDB Clone and build DuckDB as follows. git clone https://github.com/duckdb/duckdb cd duckdb GEN=ninja make Once th
...ild finishes successfully, you can find the duckdb binary in the build directory: build/release/duckdb For different build configurations ( debug , relassert , etc.), please consult the Build Configurations page . Troubleshooting Build Failure: 'string' file n... - https://man.mtool.work/duckdb/2.0/dev/building/macos.html
- Linux 10379
- Prerequisites On Linux, install the required packages with the package manager of your distribution. Ubuntu and Debian CLI Client On Ubuntu and Debian (and also MX Linux, Linux Mint, etc.), the requirements for building the DuckDB CLI clien
...ild finishes successfully, you can find the duckdb binary in the build directory: build/release/duckdb For different build configurations ( debug , relassert , etc.), please consult the “Build Configurations” page . Building Extensions To build extensions, set... - https://man.mtool.work/duckdb/2.0/dev/building/linux.html
- Securing DuckDB 8829
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...onal hardening for DuckDB deployments. However, they should not be relied upon as comprehensive security mechanisms in all configurations. These settings are designed as defense-in-depth measures to limit the impact of potential security issues, but they canno...directory: Permission Error: Cannot access file "test.csv" - file system operations are disabled by configuration Locking Configurations Security-related configuration settings generally lock themselves for safety reasons. For example, while we can disable co...ons setting while database is running This prevents re-enabling settings that were explicitly disabled. Nevertheless, many configuration settings do not disable themselves, such as the resource constraints. If you allow users to run SQL statements unrestricted... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Non-Deterministic Behavior 8516
- 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-
...egate 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'[floor(random()... - https://man.mtool.work/duckdb/2.0/operations_manual/non-deterministic_behavior.h...
- HTTP(S) Support 8202
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...T http_proxy_username = '⟨username⟩'; SET http_proxy_password = '⟨password⟩'; Note: You cannot set a proxy scope using the configurations options. Using a Custom Certificate File To use the httpfs extension with a custom certificate file, set the following con... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Legacy Authentication Scheme for S3 API 8202
- Prior to version 0.10.0, DuckDB did not have a Secrets manager . Hence, the configuration of and authentication to S3 endpoints was handled via variables. This page documents the legacy authentication scheme for the S3 API. Warning This pag
...For instance: SELECT * FROM 's3://bucket/file.parquet?s3_access_key_id=accessKey&s3_secret_access_key=secretKey'; Multiple configurations per query are also allowed: SELECT * FROM 's3://bucket/file.parquet?s3_access_key_id=accessKey1&s3_secret_access_key=secre...tKey1' t1 INNER JOIN 's3://bucket/file.csv?s3_access_key_id=accessKey2&s3_secret_access_key=secretKey2' t2; Configuration Some additional configuration options exist for the S3 upload, though the default values should suffice for most use cases.... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Schema 7889
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...d timestamp values. We run a simple aggregation query that returns the average day-of-the month from the timestamps in two configurations. First, we use a DATETIME to encode the values and run the query using the extract datetime function : SELECT avg(extract(... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- Securing Quack with a Reverse Proxy 7889
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
DuckDB 2.0 Documentation / man.mtool.work