Results of 1 - 10 of about 13 for proxy (0.003 sec.)
- HTTP(S) Support 13003
- 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
...'⟨token⟩' ); Or: CREATE SECRET http_auth ( TYPE http, EXTRA_HTTP_HEADERS MAP { 'Authorization': 'Bearer ⟨token⟩' } ); HTTP Proxy DuckDB supports HTTP proxies. You can add an HTTP proxy using the Secrets Manager : CREATE SECRET http_proxy ( TYPE http,...HTTP_PROXY '⟨http_proxy_url⟩', HTTP_PROXY_USERNAME '⟨username⟩', HTTP_PROXY_PASSWORD '⟨password⟩' ); You can also set the scope for a...n HTTP proxy using the SCOPE keyword. CREATE SECRET http_proxy ( TYPE HTTP, SCOPE ['⟨https://duckdb.org⟩', '⟨https://some-other-website... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Securing Quack with a Reverse Proxy 11929
- 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
...e / application server: put a proven HTTP reverse proxy in front of it, and let the proxy terminate TLS. The Quack client cooperates with this: for non-local URIs it assumes HTTP...uckDB's HTTPS client trusts the cert without any extra config. 1. Run Caddy Save this Caddyfile : localhost:8443 { reverse_proxy 127.0.0.1:9494 { flush_interval -1 } request_body { max_size 256MB } } Then start Caddy: brew install caddy # macOS, for o...ust store. After that, certs issued by Caddy for localhost are trusted system-wide. 2. Start Quack and Connect Through the Proxy In one DuckDB session, start the server (this prints an authentication token): {:.codebox-server} CALL quack_serve('quack:... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Azure Extension 10522
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...he token. When it expires, run CREATE OR REPLACE SECRET with a new token; it takes effect on the next query. Configuring a Proxy To configure proxy information when using secrets, you can add HTTP_PROXY , PROXY_USER_NAME and PROXY_PASSWORD in the secr...et definition. For example: CREATE SECRET secret5 ( TYPE azure, CONNECTION_STRING '⟨connection_string⟩', HTTP_PROXY 'http://localhost:3128', PROXY_USER_NAME '⟨proxy_user_name⟩', PROXY_PASSWORD '⟨proxy_password⟩' ); Note When you use secre...ts: The HTTP_PROXY environment variable is still honored, unless the secret sets HTTP_PROXY . The SET variables of Authentication with Variab... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- AWS Extension 8692
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...the SSO session's configured lifetime. When it does, run aws sso login again. You do not need to recreate the secret. HTTP Proxy When credentials must be fetched through an HTTP proxy, configure it on the secret: CREATE OR REPLACE SECRET secret ( TYPE...s3, PROVIDER credential_chain, HTTP_PROXY '⟨proxy.example.com:8080⟩', HTTP_PROXY_USERNAME '⟨username⟩', HTTP_PROXY_PASSWORD '⟨password⟩' ); Region Resolution If no... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Configuration 8181
- 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
..._keep_alive Keep alive connections. Setting this to false can help when running into connection failures BOOLEAN true http_proxy_password The password for the HTTP proxy. VARCHAR http_proxy_username The username for the HTTP proxy. VARCHAR http_proxy...The HTTP proxy host. Defaults to the HTTP_PROXY environment variable. VARCHAR http_retries HTTP retries on I/O error UBIGINT 3 http_retry... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Security 8146
- 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
...deployment beyond local-only, do not expose Quack directly to the internet. We recommend you to put a proven HTTP reverse proxy in front of it and let the proxy terminate TLS. The Quack client is shipped with these assumptions in mind: for non-local...es HTTPS by default, so a properly fronted server "just works" from the client side too. See Securing Quack with a Reverse Proxy for nginx and Caddy recipes (production and local-test). Authentication and Authorization For every database call, there a... - https://man.mtool.work/duckdb/2.0/quack/security.html
- DBeaver SQL IDE 8005
- DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It has both an open source and enterprise version. DBeaver is useful for visually inspecting the available tables in DuckDB and for quickly b
...rate environment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings. You should now see a database connection to your DuckDB database in the left hand “Database Navigator” pane. Exp...rate environment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings. Manual Driver Installation If DBeaver cannot download the driver itself, for example when it runs without write... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
- Quack Remote Protocol 7970
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...ck protocol and its interactions work as follows: HTTP-based. Quack messages travel over plain HTTP or HTTPS via a reverse proxy (see Security ). This means standard load balancers, firewalls, and reverse proxies handle Quack traffic the same way they...). For production deployments, we recommend binding the server to localhost and fronting it with a TLS-terminating reverse proxy. See Securing Quack with a Reverse Proxy . URI Format Quack endpoints use the quack: URI scheme and 9494 as the default po...ntity ( whoami ) Each Quack node exposes a whoami() table macro that surfaces basic identity and runtime info, useful when proxying to a fleet of servers or when correlating logs: {:.codebox-client} FROM remote_db.query('FROM whoami()'); ┌─────────┬──... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- UPDATE EXTENSIONS 7671
- The UPDATE EXTENSIONS statement allows synchronizing the locally installed extension state with the repository that published a given extension. This statement is the recommended way to keep up to date with new features or bug fixes being r
...g information, and sending a GET request conditional on the fact that the remote extension is different (using the ETag as proxy) than the local available one. This ensures that subsequent UPDATE EXTENSIONS calls – if the remote state has not changed... - https://man.mtool.work/duckdb/2.0/sql/statements/update_extensions.html
- Quack on WebAssembly 7636
- 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
...e 0.0.0.0:1294 port. setup via nginx a proxy between 0.0.0.0:1294 and the incoming :443 port obtain a valid TLS certificate via Let's Encrypt All together, this allows... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
DuckDB 2.0 Documentation / man.mtool.work