Results of 1 - 10 of about 77 for https (0.006 sec.)
- HTTP(S) Support 11175
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...ample, the following query will only read the Parquet metadata and the data for the column_a column: SELECT column_a FROM 'https://domain.tld/file.parquet'; In some cases, no actual data needs to be read at all as they only require reading the metadat...a: SELECT count(*) FROM 'https://domain.tld/file.parquet'; DuckDB's own database format supports partial reading just as well as Parquet. Because the for...TTP range requests to fetch only the blocks required by a query when a remote database file is attached read-only: ATTACH 'https://domain.tld/file.duckdb' AS db (READ_ONLY); SELECT column_a FROM db.tbl; As with Parquet, queries that only need the meta... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- DuckDB Installation 10954
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...mentation page curl https://install.duckdb.org | bash Direct Download duckdb-cli-osx-universal.tar.gz SHA256: 8a8f67e7c7f7d1392fa63ba3971948391392fe...fca63e7008e33c50beb4c2 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 curl https://install.duckdb.org | bash Direct Downloads duckdb-cli-linux-amd64.tar.gz SHA256: c6507206baf7793c6013dbd82368469a45f20dc...ollowing command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install.duckdb.org/install.ps1 | iex" Direct Downloads duckdb-cli-windows-amd64.tar.gz SHA256: 91663c2f36c2a334b0e5e6390... - https://man.mtool.work/duckdb/2.0/installation.html
- DuckDB Installation 10954
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...mentation page curl https://install.duckdb.org | bash Direct Download duckdb-cli-osx-universal.tar.gz SHA256: 8a8f67e7c7f7d1392fa63ba3971948391392fe...fca63e7008e33c50beb4c2 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 curl https://install.duckdb.org | bash Direct Downloads duckdb-cli-linux-amd64.tar.gz SHA256: c6507206baf7793c6013dbd82368469a45f20dc...ollowing command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install.duckdb.org/install.ps1 | iex" Direct Downloads duckdb-cli-windows-amd64.tar.gz SHA256: 91663c2f36c2a334b0e5e6390... - https://man.mtool.work/duckdb/2.0/installation/
- installation_content.html 10954
- DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client documentation page curl https://install
...fca63e7008e33c50beb4c2 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 curl https://install.duckdb.org | bash Direct Downloads duckdb-cli-linux-amd64.tar.gz SHA256: c6507206baf7793c6013dbd82368469a45f20dc...ollowing command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install.duckdb.org/install.ps1 | iex" Direct Downloads duckdb-cli-windows-amd64.tar.gz SHA256: 91663c2f36c2a334b0e5e6390...Rversion (), R.version [ "platform" ], R.version [ "arch" ], R.version [ "os" ]) )) install.packages ( "duckdb" , repos = "https://p3m.dev/cran/__linux__/manylinux_2_28/latest/" ) Direct Download (JAR) duckdb_jdbc-2.0.0.0.jar SHA256: 5170daa90a4329670... - https://man.mtool.work/duckdb/2.0/installation_content.html
- Attach to a DuckDB Database over HTTPS or S3 10291
- 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
...aching 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...loud Storage ( gs:// ) is also supported. Limitations Only read-only connections are allowed, writing the database via the HTTPS protocol or the S3 API is not possible.... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_over_https...
- Securing Quack with a Reverse Proxy 10291
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...roxy in front of it, and let the proxy terminate TLS. The Quack client cooperates with this: for non-local URIs it assumes HTTPS by default, so a properly fronted server “just works” from the client side too. This guide walks through three setups, in...order of likely usefulness: A local TLS test setup with Caddy, so you can exercise the full HTTPS path on your machine. nginx + Let's Encrypt in production. Caddy + Let's Encrypt in production. The two production setups...are interchangeable. Pick whichever fits your operational stack. Local Test Setup with Caddy You can exercise the full HTTPS path on your own machine using Caddy. Caddy issues itself a certificate for localhost from a local CA and installs the CA... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Quack on WebAssembly 9642
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...ficate via Let's Encrypt All together, this allows to expose the local 0.0.0.0:1294 port to the public EC2 instance IP via HTTPS. The template is reachable at https://duckdb-quack-ami.s3.us-east-1.amazonaws.com/quack.yaml , and is backed by images for...stance (default t3.micro) and the name of the stack (needs to be unique on the same org/region). Template is maintained at https://github.com/duckdb/duckdb-quack-infra Deploy via Web UI Visit https://console.aws.amazon.com/cloudformation/home#/stacks/...quickcreate?templateURL=https://duckdb-quack-ami.s3.us-east-1.amazonaws.com/quack.yaml&stackName=my-duckdb-quack-demo Log-in, select a name, possibly an... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- HTTP Parquet Import 8771
- To load a Parquet file 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 command: LO
...AD httpfs; After the httpfs extension is set up, Parquet files can be read over http(s) : SELECT * FROM read_parquet('https://⟨domain⟩/path/to/file.parquet'); For example: SELECT * FROM read_parquet('https://duckdb.org/data/prices.parquet'); More...over, the read_parquet function itself can also be omitted thanks to DuckDB's replacement scan mechanism : SELECT * FROM 'https://duckdb.org/data/holdings.parquet';... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_import.html
- Sharing Macros 8398
- 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
...│ └─────────┘ As one would expect, the macro gets persisted in the database. 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 M...at 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_p...e that the 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:... - https://man.mtool.work/duckdb/2.0/guides/snippets/sharing_macros.html
- Linux 8329
- Prerequisites On Linux, install the required packages with the package manager of your distribution. Ubuntu and Debian CLI Client On Ubuntu and Debian (and also MX Linux, Linux Mint, etc.), the requirements for building the DuckDB CLI clien
...following: sudo apt-get update sudo apt-get install -y git g++ cmake ninja-build libssl-dev libcurl4-openssl-dev git clone https://github.com/duckdb/duckdb cd duckdb GEN=ninja make Fedora, CentOS and Red Hat CLI Client The requirements for building th...Hat, AlmaLinux, Rocky Linux, etc. are the following: sudo yum install -y git g++ cmake ninja-build openssl-devel git clone https://github.com/duckdb/duckdb cd duckdb GEN=ninja make Note that on older Red Hat-based distributions, you may have to change..., skip Ninja and manually configure the number of Make jobs: sudo yum install -y git gcc-c++ cmake openssl-devel git clone https://github.com/duckdb/duckdb cd duckdb mkdir build cd build cmake .. make -j`nproc` Arch Linux The following instructions ar... - https://man.mtool.work/duckdb/2.0/dev/building/linux.html
DuckDB 2.0 Documentation / man.mtool.work