Results of 1 - 10 of about 22 for Signed (0.001 sec.)
- Securing Extensions 13955
- 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
...ensions are checked on every load using the signature of the binaries. There are currently three categories of extensions: Signed with a core key. Only extensions vetted by the core DuckDB team are signed with these keys. Signed with a community key. T...hese are open-source extensions distributed via the DuckDB Community Extensions repository . Unsigned. Overview of Security Levels for Extensions DuckDB offers the following security levels for extensions. Usable extensions...Description Configuration core Extensions can only be loaded if signed from a core key. SET allow_community_extensions = false core and community Extensions can only be loaded if signed from a... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- Data Types 11295
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...standard and hence might not be accepted by other database engines. Name Aliases Description BIGINT INT8 , LONG Signed eight-byte integer BIT BITSTRING String of 1s and 0s BLOB BYTEA , BINARY , VARBINARY Variable-length binary data BIGNUM Va...AT4 , REAL Single precision floating-point number (4 bytes) GEOMETRY Geospatial entity, see the GEOMETRY data type HUGEINT Signed sixteen-byte integer INTEGER INT4 , INT , SIGNED Signed four-byte integer INTERVAL Date / time delta JSON JSON object (via...the json extension ) SMALLINT INT2 , SHORT Signed two-byte integer TIME Time of day (no time zone) TIMESTAMP WITH TIME ZONE TIMESTAMPTZ Combination of time and date that us... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Extension Distribution 11194
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...outside the ones listed above, we do not officially distribute extensions (e.g., linux_arm64_android ). Extensions Signing Signed Extensions Extensions can be signed with a cryptographic key. By default, DuckDB uses its built-in public keys to verify t...he integrity of extensions before loading them. All core and community extensions are signed by the DuckDB team. In addition, custom extension repositories can serve extensions signed with their own keys: DuckDB pin...they can be distributed over HTTP without the need for HTTPS, which itself is supported through an extension ( httpfs ). Unsigned Extensions Warning Only load unsigned extensions from sources you trust. Avoid loading unsigned extensions over HTTP. Cons... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Deploy 9393
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...sit next to the JavaScript. DuckDB Extensions DuckDB extensions for DuckDB-Wasm, similar for the native cases, are served signed at the default extension endpoint: https://extensions.duckdb.org . If you are deploying duckdb-wasm you can consider mirro...lt extension repository from the public https://extensions.duckdb.org to the one specified. Note that extensions are still signed, so the best path is downloading and serving the extensions with a similar structure to the original repository. See the a...n Creating a Custom Repository . Community extensions are served at https://community-extensions.duckdb.org , and they are signed with a different key, so they can be disabled with a one way SQL statement such as: SET allow_community_extensions = false... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- Troubleshoot 9073
- Overview This page collects common issues encountered when using DuckDB-Wasm, together with their workarounds. If you run into a problem that is not covered here, search the duckdb-wasm issue tracker on GitHub. Network Error When Querying R
...only part of a file. Range requests can fail on Firefox (see issue #1932 ) and are not detected correctly for some S3 pre-signed URLs (see issue #2228 ), which forces the whole file to be downloaded or makes the read fail. Cached reads of files in Duc...es must be CORS enabled for the browser to allow the connection, exactly as for remote data files above. Extensions remain signed regardless of where they are served, so copying an extension to a different location keeps its signature valid. Out of Mem...gistering and reading remote files that are subject to the CORS rules above. Load Extensions — how extensions are fetched, signed, and served, including the httpfs CORS behavior. Deploy — serving components and configuring cross-origin isolation for th... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Loops 8535
- Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0..
...ck up these new combinations. Preset Expansion ⟨compression⟩ none uncompressed rle bitpacking dictionary fsst chimp patas ⟨signed⟩ tinyint smallint integer bigint hugeint ⟨unsigned⟩ utinyint usmallint uinteger ubigint uhugeint ⟨integral⟩ ⟨signed⟩ ⟨unsi... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- Time Functions 8434
- This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for TIME types. Operator Description Example Result + addition of an INTER
...e of the smaller time. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, starttime, endtime) The signed length of the interval between starttime and endtime , truncated to whole multiples of part . extract(part FROM time) Get...t('minute', TIME '14:21:13') | | Result | 21 | | Alias | datepart | date_sub(part, starttime, endtime) | Description | The signed length of the interval between starttime and endtime , truncated to whole multiples of part . | | Example | date_sub('hour... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Reference 8114
- 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
...query, state, hashed client id, cached rows, and query start time. quack_generate_keys(directory = ⟨path⟩) Generate a self-signed certificate ( server.pem ) and private key ( private_key.pem ) for serving over SSL. Defaults to ~/.duckdb/extension_data/...TP, other URIs to HTTPS. ssl_cert_file VARCHAR (generated) Certificate file used when serving over SSL. If omitted, a self-signed certificate is generated (see quack_generate_keys ). ssl_key_file VARCHAR (generated) Private key file used when serving o...server's certificate, e.g., the fingerprint returned by quack_generate_keys . Use this to connect to a server with a self-signed certificate. CLIENT_ID VARCHAR quack_default_client_id Client identifier sent to the server (minimum 4 characters). HEARTB... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Numeric Types 8114
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...in an error. The types UTINYINT , USMALLINT , UINTEGER , UBIGINT and UHUGEINT store whole unsigned numbers. Attempts to store negative numbers or values outside of the allowed range will result in an error. Name Aliases M...ax Size in bytes TINYINT INT1 - 2^7 2^7 - 1 1 SMALLINT INT2 , INT16 , SHORT - 2^15 2^15 - 1 2 INTEGER INT4 , INT32 , INT , SIGNED - 2^31 2^31 - 1 4 BIGINT INT8 , INT64 , LONG - 2^63 2^63 - 1 8 HUGEINT INT128 - 2^127 2^127 - 1 16 UTINYINT UINT8 0 2^8 -...R UINT32 0 2^32 - 1 4 UBIGINT UINT64 0 2^64 - 1 8 UHUGEINT UINT128 0 2^128 - 1 16 INT8 is a 64-bit integer, and is not the signed equivalent of UINT8 , an unsigned, 8-bit integer. The type aliases INT1 , INT2 , INT4 and INT8 for signed integers were in... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- SQL Quirks 8114
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...NT8 UINT8 and INT8 are aliases to integer types of different widths: UINT8 corresponds to UTINYINT because it's an 8-bit unsigned integer INT8 corresponds to BIGINT because it's an 8-byte signed integer Explanation: the n in the numeric type INTn and U.... The same applies to UINT values. However, the value n = 8 is a valid choice for both the number of bits and bytes. For unsigned values, UINT8 corresponds to UTINYINT (8 bits). For signed values, INT8 corresponds to BIGINT (8 bytes). Expressions Resul... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
DuckDB 2.0 Documentation / man.mtool.work