Results of 1 - 10 of about 31 for style (0.001 sec.)
- Pattern Matching 13912
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...e characters that can be used as keywords in place of LIKE expressions. These enhance PostgreSQL compatibility. PostgreSQL-style LIKE -style ~~ LIKE !~~ NOT LIKE ~~* ILIKE !~~* NOT ILIKE SIMILAR TO The SIMILAR TO operator returns true or false dependi...ion: SELECT NOT 'best.txt' GLOB '*.txt'; -- false Three tildes ( ~~~ ) may also be used in place of the GLOB keyword. GLOB-style Symbolic-style GLOB ~~~ Glob Function to Find Filenames The glob pattern matching syntax can also be used to search for fi...ssions DuckDB's regular expression support is documented on the Regular Expressions page . DuckDB supports some PostgreSQL-style operators for regular expression matching: PostgreSQL-style Equivalent expression ~ regexp_matches !~ NOT regexp_matches ~... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- SeaweedFS Import 11275
- Prerequisites For SeaweedFS , the S3-compatible gateway allows you to use DuckDB's S3 support to read and write from SeaweedFS buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only nee
..._secret ( TYPE s3, KEY_ID '⟨your_access_key_id⟩', SECRET '⟨your_secret_access_key⟩', ENDPOINT '⟨seaweedfs-host⟩:8333', URL_STYLE 'path', USE_SSL false ); SeaweedFS serves path-style requests, so set URL_STYLE to path . No wildcard DNS is needed. Seawe... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/seaweedfs_import....
- Fastly Object Storage Import 10563
- Prerequisites For Fastly Object Storage, the S3 Compatibility API allows you to use DuckDB's S3 support to read and write from Fastly buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This o
...EATE SECRET my_secret ( TYPE s3, KEY_ID '⟨AKIAIOSFODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩', URL_STYLE 'path', REGION '⟨us-east⟩', ENDPOINT '⟨us-east⟩.object.fastlystorage.app' -- see note below ); The ENDPOINT needs to point...you want to use (e.g., eu-central.object.fastlystorage.app ). REGION must use the same region mentioned in ENDPOINT . URL_STYLE needs to use path . Querying After setting up the Fastly Object Storage credentials, you can query the data there using Du... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/fastly_object_sto...
- Legacy Authentication Scheme for S3 API 10385
- 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
...int = '⟨domain⟩.⟨tld⟩:⟨port⟩'; If the endpoint is not SSL-enabled then run: SET s3_use_ssl = false; Switching between path-style and vhost-style URLs is possible using: SET s3_url_style = 'path'; However, note that this may also require updating the e... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Tigris Import 10385
- Prerequisites For Tigris , the S3-compatible API allows you to use DuckDB's S3 support to read and write from Tigris buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only needs to be r
...igris region nearest the caller. REGION is required for request signing but is not used for routing — set it to auto . URL_STYLE does not need to be set. Tigris uses virtual-hosted-style URLs, which is DuckDB's default for TYPE s3 . Tip When DuckDB ru... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/tigris_import.htm...
- Lambda Functions 8800
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...eprecated Syntax Deprecated DuckDB 1.3 deprecated the old lambda single arrow syntax ( x -> x + 1 ) in favor of the Python-style syntax ( lambda x : x + 1 ). DuckDB 1.3 also introduced a new setting to configure the lambda syntax. sql SET lambda_synta...x = 'enable_single_arrow'; SET lambda_syntax = 'disable_single_arrow'; From DuckDB 1.3 to 1.5, default enabled both syntax styles, i.e., the old single arrow syntax and the Python-style syntax. DuckDB 1.5 is the last release supporting the single arro...ax without explicitly enabling it. DuckDB 2.0 disables the single arrow syntax by default. Under default , only the Python-style syntax is enabled; use SET lambda_syntax = 'enable_single_arrow' to revert to the deprecated behavior. DuckDB 2.1 will rem... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- Building Configuration 8622
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...nd for release with BUILD_BENCHMARK=1 set. tidy-check This creates a build and then runs Clang-Tidy to check for issues or style violations through static analysis. The CI will also run this check, causing it to fail if this check fails. format-fix |...format-changes | format-main This doesn't actually create a build, but uses the following format checkers to check for style issues: clang-format to fix format issues in the code. cmake-format to fix format issues in the CMakeLists.txt files. The... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- ODBC API Overview 8266
- Installation To use the DuckDB ODBC client, visit the ODBC installation page . The latest stable version of the DuckDB ODBC client is 2.0.0. This page describes the DuckDB ODBC driver, which lets other applications connect to DuckDB . To co
...nnect from DuckDB to other databases over ODBC, use the odbc extension . The ODBC (Open Database Connectivity) is a C-style API that provides access to different flavors of Database Management Systems (DBMSs). The ODBC API consists of the Driver... - https://man.mtool.work/duckdb/2.0/clients/odbc/overview.html
- Unit Tester Configuration 8266
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...s are OR'd) --skip-tag-set <comma-separated strings> Skip tests which match all named tags (multiple sets are OR'd) --sort-style <none|rowsort|valuesort> Default sort style if none is configured in the test --statically-loaded-extensions <comma-separa... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- MySQL Import 8266
- To run a query directly on a running MySQL database, the mysql extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL mysql; To load the mysql ex
...user=root port=0 database=mysqlscanner' AS mysql_db (TYPE mysql); USE mysql_db; The string used by ATTACH is a PostgreSQL-style connection string ( not a MySQL connection string!). It is a list of connection arguments provided in {key}={value} format... - https://man.mtool.work/duckdb/2.0/guides/database_integration/mysql.html
DuckDB 2.0 Documentation / man.mtool.work