Results of 1 - 10 of about 23 for blobs (0.001 sec.)
- Sharing Macros 13958
- DuckDB has a powerful macro mechanism that allows creating shorthands for common tasks. Sharing a Scalar Macro First, we define a macro that pretty-prints a non-negative integer as a short string with thousands, millions, and billions (with
...se. But this also means that we can host it on an HTTPS endpoint and share it with anyone! We have published this macro on blobs.duckdb.org . You can try it from DuckDB: duckdb Make sure that the httpfs extension is installed: INSTALL httpfs; You can...now attach to the remote endpoint and use the macro: ATTACH 'https://blobs.duckdb.org/data/pretty_print_integer_macro.duckdb' AS pretty_print_macro_db; SELECT pretty_print_macro_db.pretty_print_int...he httpfs extension is installed: INSTALL httpfs; You can attach to the remote endpoint and use the macro: ATTACH 'https://blobs.duckdb.org/data/compute_table_checksum.duckdb' AS compute_table_checksum_db; CREATE TABLE stations AS FROM 'https://blobs.... - https://man.mtool.work/duckdb/2.0/guides/snippets/sharing_macros.html
- Attach to a DuckDB Database over HTTPS or S3 11277
- You can establish a read-only connection to a DuckDB instance via HTTPS or the S3 API. Prerequisites This guide requires the httpfs extension , which can be installed using the INSTALL httpfs SQL command. This only needs to be run once. Att
...g to a Database over HTTPS To connect to a DuckDB database via HTTPS, use the ATTACH statement as follows: ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stations_db; Then, the database can be queried using: SELECT count(*) AS num_stat...configure the authentication for your bucket (if required). Then, use the ATTACH statement as follows: ATTACH 's3://duckdb-blobs/databases/stations.duckdb' AS stations_db; The database can be queried using: SELECT count(*) AS num_stations FROM station... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_over_https...
- Blob Type 10891
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
...ng with DuckDB 2.0, X'…' literals are BLOB values. In earlier versions, X'CAFE' was parsed as the VARCHAR string 'xCAFE' . Blobs are typically used to store non-textual objects that the database does not provide explicit support for, such as images. W...hile blobs can hold objects up to 4 GB in size, typically it is not recommended to store very large objects within the database syste... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- ATTACH and DETACH Statements 9735
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...these, it creates a read-only connection by default. Therefore, the following two commands are equivalent: ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stations_db; ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stati...ons_db (READ_ONLY); Similarly, the following two commands connecting to S3 are equivalent: ATTACH 's3://⟨blobs-duckdb⟩/databases/stations.duckdb' AS stations_db; ATTACH 's3://⟨blobs-duckdb⟩/databases/stations.duckdb' AS stations_db (... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- Blob Functions 8964
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...nverts a value from hexadecimal representation to a blob. arg1 || arg2 | Description | Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2, ...) . | | Example 1 | 'D... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Directly Read DuckDB Databases 8395
- DuckDB allows directly reading DuckDB files through the read_duckdb function: read_duckdb(⟨'path_to_database'⟩, table_name = ⟨'table_to_read'⟩); Using this function is equivalent to performing the following steps: Attaching to the database
...Specific Table To read the region table from the TPC-H dataset, run: SELECT r_regionkey, r_name FROM read_duckdb('https://blobs.duckdb.org/data/tpch-sf10.db', table_name = 'region'); ┌─────────────┬─────────────┐ │ r_regionkey │ r_name │ │ int32 │ va... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_duckdb.html
- HTTP CSV Import 8395
- To load a CSV file directly over HTTP(S), the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL httpfs; To load the httpfs extension for usage, use the LOAD SQL comman
...h no local download step: SELECT area, round(avg(sunbed_price), 0) AS avg_sunbed_price_eur, count(*) AS clubs FROM 'http://blobs.duckdb.org/data/beach-clubs.csv' WHERE sunbed_price IS NOT NULL GROUP BY area ORDER BY avg_sunbed_price_eur DESC; ┌───────... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_csv_import.h...
- Dutch Railway Datasets 8395
- Examples in this documentation often use datasets based on the Dutch Railway datasets . These high-quality datasets are maintained by the team behind the Rijden de Treinen (Are the trains running?) application . This page contains download
...hese datasets . Loading the Datasets You can load the datasets directly as follows: CREATE TABLE services AS FROM 'https://blobs.duckdb.org/nl-railway/services-2025-03.csv.gz'; DESCRIBE services; column_name column_type null key default extra Service:... - https://man.mtool.work/duckdb/2.0/guides/snippets/dutch_railway_datasets.html
- HTTP User-Agent 8395
- HTTP User-Agent Core DuckDB sets the default user-agent as follows: duckdb/v2.0.0(osx_arm64) cli which indicates the DuckDB version, the platform and the client API (the value of the duckdb_api setting, e.g., cli , capi or cpp ). If the cus
...Nov 18 21:07:05 PST 2025; root:xnu-12377.61.12~1/RELEASE_ARM64_T6020 Cpp/201402) via Azure Blob/ADLSv2: azsdk-cpp-storage-blobs/12.15.0 (Darwin 25.2.0 arm64 Darwin Kernel Version 25.2.0: Tue Nov 18 21:07:05 PST 2025; root:xnu-12377.61.12~1/RELEASE_AR... - https://man.mtool.work/duckdb/2.0/operations_manual/user_agents.html
- Describe 8210
- Describing a Table To view the schema of a table, use the DESCRIBE statement (or its alias DESC ) followed by the table name. CREATE TABLE tbl (i INTEGER PRIMARY KEY, j VARCHAR); DESCRIBE tbl; column_name column_type null key default extra
...o describe remote tables via the httpfs extension using the DESCRIBE TABLE statement. For example: DESCRIBE TABLE 'https://blobs.duckdb.org/data/Star_Trek-Season_1.csv'; column_name column_type null key default extra season_num BIGINT YES NULL NULL NU... - https://man.mtool.work/duckdb/2.0/guides/meta/describe.html
DuckDB 2.0 Documentation / man.mtool.work