Results of 1 - 10 of about 19 for localhost (0.002 sec.)
- Quack Remote Protocol 13216
- 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
...sion can see (in-memory tables, attached files, schemas) becomes reachable over the remote protocol. To start listening on localhost, run: {:.codebox-server} CALL quack_serve('quack:localhost'); The URI argument is optional: calling quack_serve() without...it also listens on quack:localhost . quack_serve returns the listen URI, the HTTP URL, and, when the default authentication function is in use, the auth_toke...onnect. To choose the token yourself, pass the token parameter (see Security ): {:.codebox-server} CALL quack_serve('quack:localhost', token = '⟨my_token⟩'); Tip The DuckDB CLI can start a server directly with the -serve argument and connect to one with -... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Securing Quack with a Reverse Proxy 11901
- 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
...tup 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 root into your system trust store, so DuckDB's HTTPS client trusts the cert without an...y 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...will prompt for elevation to install Caddy's local CA into your system trust 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... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- File Access with the file: Protocol 10228
- DuckDB supports using the file: protocol. It currently supports the following formats: file:/some/path (host omitted completely) file:///some/path (empty host) file://localhost/some/path ( localhost as host) Note that the following formats
...elative path) file://some/path (double-slash path) Additionally, the file: protocol currently does not support remote (non-localhost) hosts.... - https://man.mtool.work/duckdb/2.0/guides/file_formats/file_access.html
- Reference 10006
- 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
...erver on listen_uri , which defaults to quack:localhost when omitted. Localhost-only by default. Returns the listen URI, the listen URL, and the authentication token. See the qua...ty + runtime info for the current node. quack_serve Parameters Parameter Type Default Description listen_uri VARCHAR quack:localhost Positional. The Quack URI to listen on. allow_other_hostname BOOLEAN false Allow binding to a non-local hostname, e.g., 0....tructured log of every Quack message (both client- and server-side): CALL enable_logging('Quack'); FROM quack_query('quack:localhost', 'SELECT 42'); SELECT * FROM duckdb_logs_parsed('Quack'); context_id scope connection_id transaction_id query_id thread_i... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- PostgreSQL Import 9271
- To run a query directly on a running PostgreSQL database, the postgres extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL postgres; To load t
...ided in {key}={value} format. Below is a list of valid arguments. Name Description Default host Name of host to connect to localhost hostaddr Host IP address localhost port Port number 5432 user PostgreSQL user name [OS user name] password PostgreSQL pass...of file passwords are stored in ~/.pgpass -- Attach the PostgreSQL database using the given connection string ATTACH 'host=localhost port=5432 dbname=mydb' AS test (TYPE postgres); -- The table "tbl_name" can now be queried as if it is a regular table SEL... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- MySQL Extension 8896
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...o make a MySQL database accessible to DuckDB use the ATTACH command with the mysql or the mysql_scanner type: ATTACH 'host=localhost user=root port=0 database=mysql' AS mysqldb (TYPE mysql); USE mysqldb; Warning Avoid including credentials, such as a pass...sion tries to read it from an environment variable. Setting Default Environment variable database NULL MYSQL_DATABASE host localhost MYSQL_HOST password MYSQL_PWD port 0 MYSQL_TCP_PORT socket NULL MYSQL_UNIX_PORT user current user MYSQL_USER ssl_mode pref...arquet file into MySQL. Below is a brief example of how to create a new table in MySQL and load data into it. ATTACH 'host=localhost user=root port=0 database=mysqlscanner' AS mysql_db (TYPE mysql); CREATE TABLE mysql_db.tbl (id INTEGER, name VARCHAR); IN... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Troubleshooting Quack 8691
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...RET iceberg_catalog_secret, TABLE_RESOLUTION 'eager' ); CREATE TABLE local_data AS SELECT 42 AS i; CALL quack_serve('quack:localhost', token = 'example-token'); The client can then attach and query as usual: {:.codebox-client} -- Client, in a separate Duc...kDB instance. LOAD quack; ATTACH 'quack:localhost' AS remote (TOKEN 'example-token'); FROM remote.local_data; Eager resolution adds metadata-loading work and can increase c...query() , which runs SQL directly on the server without importing its catalog: {:.codebox-client} FROM quack_query( 'quack:localhost', 'SELECT count(*) FROM ice.demo.orders', token = 'example-token' );... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- MySQL Import 8469
- 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
...Usage After the mysql extension is installed, you can attach to a MySQL database using the following command: ATTACH 'host=localhost user=root port=0 database=mysqlscanner' AS mysql_db (TYPE mysql); USE mysql_db; The string used by ATTACH is a PostgreSQL-...list of valid arguments. Any options not provided are replaced by their default values. Setting Default database NULL host localhost password port 0 socket NULL user current user You can directly read and write the MySQL database: CREATE TABLE tbl (id INT... - https://man.mtool.work/duckdb/2.0/guides/database_integration/mysql.html
- PostgreSQL Extension 8315
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...command with the postgres or postgres_scanner type. To connect to the public schema of the PostgreSQL instance running on localhost in read-write mode, run: ATTACH '' AS postgres_db (TYPE postgres); To connect to the PostgreSQL instance with the given pa...parameters. A full list of available parameters can be found in the PostgreSQL documentation . dbname=postgresscanner host=localhost port=5432 dbname=mydb connect_timeout=10 Name Description Default dbname Database name [user] host Name of host to connect...to localhost hostaddr Host IP address localhost passfile Name of file passwords are stored in ~/.pgpass password PostgreSQL password (e... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- Security 8093
- 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
...en is passed explicitly or supplied by a quack secret, the server generates a random token at startup. The server binds to localhost only, non-local hostnames require an explicit allow_other_hostname = true . The server does not use TLS for local URIs, as...TLS for localhost communication only adds dependencies for no real benefit. Non-local URIs default to HTTPS with a self-signed certificate (...read_only(sid, query) AS ( regexp_matches(upper(trim(query)), '^(SELECT|FROM|WITH|EXPLAIN)\b') ); CALL quack_serve('quack:localhost', token = 'analytics-team-token'); SET GLOBAL quack_authentication_function = 'check_token'; SET GLOBAL quack_authorizatio... - https://man.mtool.work/duckdb/2.0/quack/security.html
DuckDB 2.0 Documentation / man.mtool.work