Results of 1 - 10 of about 26 for the global (0.003 sec.)
the (457), global (26)
- SET and RESET Statements 18430
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...configuration option to default value: RESET threads; Retrieve configuration value: SELECT current_setting('threads'); Set the default collation for the session: SET SESSION default_collation = 'nocase'; Set a Global Variable Set the default sort or...der globally: SET GLOBAL default_order = 'DESC'; Set the default threads globally: SET GLOBAL threads = 4; Syntax SET updates a DuckD...B configuration option to the provided value. RESET The RESET statement changes the given DuckDB configuration option to the default value. Scopes Confi... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- Configuration 18069
- 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
...ng the RESET statement . The values of configuration options can be queried via the current_setting() scalar function or using th...'memory_limit') AS memlimit; Or: SELECT value AS memlimit FROM duckdb_settings() WHERE name = 'memory_limit'; Examples Set the memory limit of the system to 10 GB. SET memory_limit = '10GB'; Configure the system to use 1 thread. SET threads TO 1; Tu...name = 'threads'; name value description input_type scope threads 1 The number of total threads used by the system. BIGINT GLOBAL Show a list of all available settings: SELECT * FROM duckdb_settings(); Reset the memory limit of the system back to the d... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Reference 14353
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...erver on listen_uri , which defaults to quack:localhost when omitted. Localhost-only by default. Returns the listen URI, the listen URL, and the authentication token. See the quack_serve parameters below. quack_stop(listen_uri) Sto...p the server listening on listen_uri . quack_server_list() List the servers running in this instance: listen URI and URL, host,...t_timeout Heartbeat lease timeout in seconds requested from the server. Settings All settings are regular DuckDB session / global options. Set with SET ⟨name⟩ = ⟨value⟩ or SET GLOBAL . Authentication / Authorization The auth callbacks are evaluated on... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Security 14121
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...ry. Exposure Model A Quack server exposes the full SQL surface of the underlying DuckDB instance, including read and write access to every table the server's session ca...n see. Because of this, the extension ships with conservative defaults that prevent accidental exposure: The server requires an authentication token ,...eck_token(sid, client_token, server_token) AS ( EXISTS (SELECT 1 FROM quack_tokens WHERE auth_token = client_token) ); SET GLOBAL quack_authentication_function = 'check_token'; Now any client whose token is in quack_tokens is admitted, everyone else is... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Pragmas 13425
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...subsequent execution or behavior of the engine. Configure DuckDB settings using the SET statement . You can retrieve a setting's value using SELECT current_settin...Assigning configuration settings with PRAGMA name = value is deprecated and emits a warning. Use SET name = value instead. The warning becomes an error when warnings_as_errors is enabled. Function-style PRAGMA calls (for example, PRAGMA table_info('...ecution time . The default is 0 , meaning no limit. SET max_execution_time = 5000; This is a per-connection setting with a global fallback: a local value overrides a value set with SET GLOBAL , and RESET max_execution_time restores the global value. Co... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Files Created by DuckDB 13311
- DuckDB creates several files and directories on disk. This page lists both the global and the local ones. Global Files and Directories DuckDB creates the following global files and directories in the user's home directory (denoted with ~ ):
...Location Description Shared between versions Shared between clients ~/.duckdbrc The content of this file is executed when starting the DuckDB CLI client . The commands can be both dot command and SQL statem...ents. The naming of this file follows the ~/.bashrc and ~/.zshrc “run commands” files. Yes Only used by CLI ~/.duckdb_history Histor... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/files_cr...
- Regular Expressions 13163
- DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Expression Syntax DuckDB uses the RE2 library as its regular expression engine. For the regular express
...ion syntax, see the RE2 docs . Functions All functions accept an optional set of options . Name Description regexp_extract(string, pattern[, g...roup = 0][, options]) If string contains the regexp pattern , returns the capturing group specified by optional parameter group ; otherwise, returns the empty string....ching part with replacement . By default, only the first occurrence is replaced. A set of optional options , including the global flag g , can be set. regexp_split_to_array(string, regex[, options]) Alias of string_split_regex . Splits the string along... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Connect 12918
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...nd how to reach a remote DuckDB server over Quack . Opening a Connection In JDBC, database connections are created through the standard java.sql.DriverManager class. On modern JVMs the driver registers itself with the DriverManager automatically whe...n the JDBC JAR is on the classpath (through Java's service-provider mechanism ), so no setup is needed. If that does not happen...does not recognize as its own to DuckDB. Note that many of these settings can also be changed later on with a SET (or SET GLOBAL ) statement , or the equivalent PRAGMA . Properties connectionProperties = new Properties(); connectionProperties.setPrope... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- DuckDB_% Metadata Functions 12889
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...used just like an ordinary table or view. For example, you can use a duckdb_ function call in the FROM clause of a SELECT statement, and you may refer to the columns of its returned resultset elsewhere in the statement,...for example in the WHERE clause. Table functions are still functions, and you should write parentheses after the function name to call it to...etting. VARCHAR input_type The logical data type of the setting's value. VARCHAR scope The scope of the setting ( LOCAL or GLOBAL ). VARCHAR New As of DuckDB 2.0, duckdb_settings() accepts the debug , deprecated , and include_all named parameters. By d... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- SET VARIABLE and RESET VARIABLE Statements 12692
- DuckDB supports the definition of SQL-level variables using the SET VARIABLE and RESET VARIABLE statements. Variable Scopes DuckDB supports two levels of variable scopes: Scope Description SESSION Variables with a SESSION scope are local to
...you and only affect the current session. GLOBAL Variables with a GLOBAL scope are specific configuration option variables that affect the entire D...uckDB instance and all sessions. For example, see Set a Global Variable . SET VARIABLE The SET VARIABLE statement assigns a value to a variable, which can be accessed using the getvaria...ble call: SET VARIABLE my_var = 30; SELECT 20 + getvariable('my_var') AS total; total 50 New The $⟨variable⟩ shorthand was introduced in DuckDB 2.0. As a shorthand for getvariable , a variable can be referenced directly... - https://man.mtool.work/duckdb/2.0/sql/statements/set_variable.html
DuckDB 2.0 Documentation / man.mtool.work