Results of 1 - 10 of about 37 for allowed (0.006 sec.)
- Configuration 12676
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...sions build by the community. BOOLEAN true allow_extension_repositories Whether custom trusted extension repositories are 'allowed', 'forbidden' (which also distrusts existing repositories) or 'undecided' (the default: blocks adding new repositories, bu...t keeps trusting existing ones). While the database is running the setting can only move from 'undecided' to 'allowed' or 'forbidden', or from 'allowed' to 'forbidden'. VARCHAR undecided allow_extensions_metadata_mismatch Allow to load exte...ecrets. BOOLEAN false allow_unsigned_extensions Allow to load extensions with invalid or missing signatures. BOOLEAN false allowed_configs List of configuration options that are ALWAYS allowed to be changed, even when lock_configuration is true. VARCHAR... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Extension Repositories 12234
- New Support for custom extension repositories was introduced in DuckDB 2.0. This feature is currently work-in-progress and the syntax may still change. By default, DuckDB installs extensions from its built-in repositories ( core , core_nigh
...t has three values: undecided (the default): adding new repositories is blocked, but existing repositories remain trusted. allowed : custom repositories can be added. forbidden : adding new repositories is blocked and existing custom repositories are di...strusted. While the database is running, the setting can only move from undecided to allowed or forbidden , or from allowed to forbidden . To opt in: SET allow_extension_repositories = 'allowed'; Creating a Reposito... - https://man.mtool.work/duckdb/2.0/extensions/extension_repositories.html
- Securing DuckDB 12234
- 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
...m or write to files. Functions such as read_csv , read_parquet , read_json , etc. cannot read from an external source. The allowed_directories and allowed_paths Options You can restrict DuckDB's access to certain directories or files using the allowed_d...irectories and allowed_paths options (respectively). These options allow fine-grained access control for the file system. For example, you can se...t DuckDB to only use the /tmp directory. SET allowed_directories = ['/tmp']; SET enable_external_access = false; FROM read_csv('test.csv'); With the setting applied, DuckDB wi... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Numeric Functions 10908
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...loored definition. Always returns a DOUBLE value. gamma(x) Interpolation of the factorial of x - 1 . Fractional inputs are allowed. gcd(x, y) Computes the greatest common divisor of x and y . greatest_common_divisor(x, y) Computes the greatest common di...s INTEGER) Alias of roundbankers(v, s) . Round to s decimal places using the rounding half to even rule . Values s < 0 are allowed. roundbankers(v NUMERIC, s INTEGER) Alias of round_even(v, s) . Round to s decimal places using the rounding half to even...rule . Values s < 0 are allowed. round(v NUMERIC, s INTEGER) Round to s decimal places. Values s < 0 are allowed. setseed(x) Sets the seed to be used for... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Securing Extensions 9440
- 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
...rovided keys. Two settings control them: allow_extension_repositories : whether custom trusted extension repositories are 'allowed' , 'forbidden' (which also distrusts existing repositories) or 'undecided' (the default: blocks adding new repositories, b...ut keeps trusting existing ones). While the database is running, the setting can only move from 'undecided' to 'allowed' or 'forbidden' , or from 'allowed' to 'forbidden' . extension_repository_directory : the directory in which trusted exten... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- Directly Reading Files 8555
- DuckDB allows directly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames, or a glob pattern. They output the content of each file as a VARCHAR or BLOB , respectively, along with
...an error suggesting to use read_blob instead. read_text also supports reading from pipes (e.g., /dev/stdin ). The maximum allowed file size for read_text is 3.9 GiB. read_blob The read_blob table function reads from the selected source(s) to a BLOB : S...test/sql/table_function/files/three.txt 10 F\xC3\xB6\xC3\xB6 B\xC3\xA4r test/sql/table_function/files/two.txt The maximum allowed file size for read_blob is 3.9 GiB. Schema The schemas of the tables returned by read_text and read_blob are identical: DE... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_file.html
- Typecasting 8413
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...lways be converted between types. The following matrix describes which conversions are supported. When implicit casting is allowed, it implies that explicit casting is also possible. The matrix is generated from the documented DuckDB version by scripts/...e if it would result in an invalid target value, for example due to overflows . Deprecated Prior to version 0.10.0, DuckDB allowed any type to be implicitly cast to VARCHAR during function binding. Version 0.10.0 introduced a breaking change which no lo...note that this flag will be deprecated in the future. Lossy Casts Casting operations that result in loss of precision are allowed. For example, it is possible to explicitly cast a numeric type with fractional digits – such as DECIMAL , FLOAT or DOUBLE... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- SQL on Pandas 8271
- Pandas DataFrames stored in local variables can be queried as if they are regular tables within DuckDB. import duckdb import pandas # Create a Pandas dataframe my_df = pandas.DataFrame.from_dict({'a': [42]}) # query the Pandas DataFrame "my
...results = duckdb.sql("SELECT * FROM my_df").df() The seamless integration of Pandas DataFrames into DuckDB SQL queries is allowed by replacement scans , which replace instances of accessing the my_df table (which does not exist in DuckDB) with a table... - https://man.mtool.work/duckdb/2.0/guides/python/sql_on_pandas.html
- Release Cycle 8113
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
...1>-codename Description The feature freeze phase is the phase closest to release. During this phase features are no longer allowed to be merged into vx.<y+1>-codename and only bug fixes are merged. This phase is intended to ensure the quality of the upc...risk of introducing last-minute bugs by disallowing feature merges. PRs into DuckDB Bug-fixes for vx.y.<z+1> are no longer allowed, should target vx.<y+1>.0 instead Bug-fixes for vx.<y+1>.0 are merged into vx.<y+1>-codename Features for vx.<y+1>.0 are n...o longer allowed, should target vx.<y+2>.0 instead Features for vx.<y+2>.0 are merged into main Main Extension Release Cycle Most DuckDB ex... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- PostgreSQL Extension Connection Pool 7971
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...tions. To prevent this, these parallel queries (for the same table scan) are additionally limited by the maximum number of allowed connection in the connection pool (no more than 32 by default). Even when the connection pool is configured to allow openi...ailable) pg_pool_max_connections ( UBIGINT , default: 4 <= cpu_count * 1.5 <= 32 ): maximum number of connections that are allowed to be cached in a connection pool for each attached Postgres database. This number can be temporary exceeded when parallel... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
DuckDB 2.0 Documentation / man.mtool.work