Results of 1 - 10 of about 40 for environment (0.002 sec.)
- jemalloc 12325
- On supported platforms, DuckDB replaces the system's memory allocator with jemalloc . jemalloc is statically linked into DuckDB and cannot be installed or loaded during runtime. For technical reasons, we used to distribute jemalloc as an ex
...macOS and Windows, jemalloc is not available. DuckDB uses the system's memory allocator on these platforms. Configuration Environment Variables The jemalloc allocator in DuckDB can be configured via the DUCKDB_JE_MALLOC_CONF environment variable. Setting t...his is equivalent to setting the MALLOC_CONF environment variable for jemalloc but DuckDB uses a different environment variable name to avoid potential name clashes with other app... - https://man.mtool.work/duckdb/2.0/internals/jemalloc.html
- ODBC 101: A Duck Themed Guide to ODBC 11249
- What is ODBC? ODBC which stands for Open Database Connectivity, is a standard that allows different programs to talk to different databases including, of course, DuckDB. This makes it easier to build programs that work with many different d
...to interact with the database. There are several different types of handles, each with a different purpose, these are the environment handle, the connection handle, the statement handle, and the descriptor handle. Handles are allocated using the SQLAllocHa...handle of the specified type, which it returns to the application. The DuckDB ODBC driver has the following handle types. Environment | Handle name | Environment | | Type name | SQL_HANDLE_ENV | | Description | Manages the environment settings for ODBC ope...connect to the data source so that the application can perform database operations. First the application must allocate an environment handle, and then a connection handle. The connection handle is then used to connect to the data source. There are two func... - https://man.mtool.work/duckdb/2.0/guides/odbc/general.html
- Command Line Client 10827
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...gate to that directory in a terminal and enter the command duckdb to run the executable. If in a PowerShell or POSIX shell environment, use the command ./duckdb instead. Usage The typical usage of the duckdb command is the following: duckdb ⟨OPTIONS⟩ ⟨FILEN...or not writable, startup can fail with an error such as IO Error: Failed to create directory . In sandboxed or restricted environments, set the HOME environment variable to a writable location to control where these files are created. See Files Created by...k head and run a SQL statement. Note that the duck head is built with Unicode characters and does not work in all terminal environments (e.g., in Windows, unless running with WSL and using the Windows Terminal). .prompt "{color:yellow1}{sql:select current_d... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- UI Extension 10297
- The ui extension adds a user interface for your local DuckDB instance. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui(); Running either of these will open the UI in your default browser. The
...ded will be available. Since this instance is a native process (not Wasm), it can leverage all the resources of your local environment: all cores, memory and files. Closing this instance will cause the UI to stop working. The UI is served from an HTTP serve...tion Local Port The local port of the HTTP server can be configured with a SQL command like: SET ui_local_port = 4213; The environment variable ui_local_port can also be used. The default port is 4213. (Why? 4 = D, 21 = U, 3 = C) Remote URL The local HTTP s....org . An alternate remote URL can be configured with a SQL command like: SET ui_remote_url = 'https://ui.duckdb.org'; The environment variable ui_remote_url can also be used. This setting is available mainly for testing purposes. Be sure you trust any URL... - https://man.mtool.work/duckdb/2.0/core_extensions/ui.html
- Python 9876
- 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
...0 installed You run commands from the root of the duckdb-python source We are opinionated about using Astral UV for Python environment and dependency management. While using pip for a development environment with an editable install without build isolation...of commits in the submodule, so do not make a shallow clone 2. Install Astral uv Install 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...g installed: Visual Studio 2019+ with C++ support Git for Windows 2. Install Dependencies and Build Set up the development environment in two steps: # Install the build dependencies without building the project uv sync --only-group build --no-install-projec... - https://man.mtool.work/duckdb/2.0/dev/building/python.html
- Command Line 9751
- Unexpected Markdown Output When Piping If the output of the command line client is piped to another process and an AI agent environment variable (such as AI_AGENT ) is set, the CLI switches to agent mode and prints compact Markdown tables i
...at | x:INTEGER | |---| | 42 | To turn off agent mode, use the -no-agent command line argument or set the DUCKDB_AGENT_MODE environment variable to 0 : echo "SELECT 42 AS x;" | duckdb -no-agent | cat ┌───────┐ │ x │ │ int32 │ ├───────┤ │ 42 │ └───────┘ Passi... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/command_line.html
- Agent Mode 9610
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...” blog post . Activating Agent Mode Agent mode is activated automatically when all of the following hold: A known AI agent environment variable (such as AI_AGENT ) is set. The standard output is not a terminal (for example, it is piped to another process)....rol agent mode explicitly: The -agent and -no-agent command line arguments force the mode on or off. The DUCKDB_AGENT_MODE environment variable forces the mode on ( 1 ) or off ( 0 ). The command line flags take precedence over the environment variable. To h... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- DBeaver SQL IDE 9345
- DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It has both an open source and enterprise version. DBeaver is useful for visually inspecting the available tables in DuckDB and for quickly b
...ckDB's JDBC driver from Maven. Once download is complete, click “OK”, then click “Finish”. Note: If you are in a corporate environment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings....mplete, click “OK”, then return to the main DBeaver window and continue with step 7 above. Note: If you are in a corporate environment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings.... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
- PostgreSQL Extension 8924
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...greSQL connection information can also be specified with secrets , see details on the corresponding page . Configuring via Environment Variables PostgreSQL connection information can also be specified with environment variables . This can be useful in a pro...duction environment where the connection information is managed externally and passed in to the environment. export PGPASSWORD="secret" export...ror true pg_oauth_token OAuth bearer token for PostgreSQL OAUTHBEARER authentication. Takes priority over the PGOAUTHTOKEN environment variable NULL pg_pages_per_task The amount of pages per task 1000 pg_query_mode Query mode used to read data, one of 'AUTO... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- AWS Extension 8659
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...est-1⟩' ); Selecting a Profile To load credentials based on a named profile which is not the default (from the AWS_PROFILE environment variable or the default profile based on AWS SDK precedence), use the PROFILE parameter: CREATE OR REPLACE SECRET secret (...owing sources, in order: The REGION secret parameter. The s3_region setting ( SET s3_region = '⟨region⟩' ). The AWS_REGION environment variable. The AWS_DEFAULT_REGION environment variable. The region of the profile in ~/.aws/config . If none of these resol...REATE SECRET statement, adding a region to your profile in ~/.aws/config or configure the AWS_REGION or AWS_DEFAULT_REGION environment variables. Validation The AWS credential_chain provider will look for any required credentials during CREATE SECRET time,... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
DuckDB 2.0 Documentation / man.mtool.work