Results of 1 - 10 of about 29 for host (0.002 sec.)
- DuckDB Docker Container 12204
- DuckDB has an official Docker image , which supports both the ARM64 (AArch64) and x86_64 (AMD64) architectures. Usage To use the DuckDB Docker image, run: docker run --rm -it -v "$(pwd):/workspace" -w /workspace duckdb/duckdb Using the Duck
...DB UI with Docker To use the DuckDB UI with Docker, enable host networking. This setting forwards all ports from the container, so exercise caution and avoid it in secure environments. d...ocker run --rm -it -v "$(pwd):/workspace" -w /workspace --net host duckdb/duckdb Then, launch the UI as follows: CALL start_ui(); To enable host networking in Docker Desktop, follow the ins...tructions on the Host network driver page.... - https://man.mtool.work/duckdb/2.0/operations_manual/duckdb_docker.html
- PostgreSQL Import 11094
- 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
...ist of connection arguments provided 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 [O...Name 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... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- File Access with the file: Protocol 11094
- 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
...ve 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
- MySQL Extension 10898
- 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.
...SQL To 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...extension 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...tion can also be specified with secrets . The following syntax can be used to create a secret. CREATE SECRET ( TYPE mysql, HOST '127.0.0.1', PORT 0, DATABASE mysql, USER 'mysql', PASSWORD '' ); The information from the secret will be used when ATTACH... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- PostgreSQL Extension and the Secret Manager 10409
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...stgreSQL database instances. Secrets can be given a name upon creation. CREATE SECRET postgres_secret_one ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE postgres, USER 'postgres', PASSWORD '' ); The secret can then be explicitly referenced us...t a number of configuration options. The following options are named after the corresponding connection options of libpq : HOST HOSTADDR PORT DBNAME USER PASSWORD PASSFILE REQUIRE_AUTH CHANNEL_BINDING CONNECT_TIMEOUT CLIENT_ENCODING OPTIONS APPLICATI...OTOCOL_VERSION KRBSRVNAME GSSLIB GSSDELEGATION SCRAM_CLIENT_KEY SCRAM_SERVER_KEY SERVICE TARGET_SESSION_ATTRS LOAD_BALANCE_HOSTS OAUTH_ISSUER OAUTH_CLIENT_ID OAUTH_CLIENT_SECRET OAUTH_SCOPE The following options are renamed to the corresponding keys:... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- inet Extension 10295
- The inet extension defines the INET data type for storing IPv4 and IPv6 Internet addresses. It supports the CIDR notation for subnet masks (e.g., 198.51.100.0/22 , 2001:db8:3c4d::/48 ). Installing and Loading The inet extension will be tran
...c4d:15::1a2f:1a2b'); SELECT cidr FROM tbl ORDER BY cidr ASC; cidr 127.0.0.1 127.0.0.11 2001:db8:3c4d:15::1a2f:1a2b fe80::7 host Function The host component of an INET value can be extracted using the HOST() function. CREATE TABLE tbl (cidr INET); INS...ERT INTO tbl VALUES ('192.168.0.0/16'), ('127.0.0.1'), ('2001:db8:3c4d:15::1a2f:1a2b/96'); SELECT cidr, host(cidr) AS host FROM tbl; cidr host 192.168.0.0/16 192.168.0.0 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3... - https://man.mtool.work/duckdb/2.0/core_extensions/inet.html
- PostgreSQL Extension 9495
- 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
...and 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...rameters in read-only mode, run: ATTACH 'dbname=postgres user=postgres host=127.0.0.1' AS db (TYPE postgres, READ_ONLY); By default, all schemas are attached. When working with large instances, it c...to only attach a specific schema. This can be accomplished using the SCHEMA command. ATTACH 'dbname=postgres user=postgres host=127.0.0.1' AS db (TYPE postgres, SCHEMA 'public'); The transaction isolation level can be set with the ISOLATION_LEVEL opt... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- Catalogs 8696
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...thwest-1 ), which use amazonaws.com.cn . For such regions, attach the catalog by passing an explicit URI (with the correct host for your region) together with AUTHORIZATION_TYPE 'sigv4' , instead of using ENDPOINT_TYPE . To check whether the attachme...north-1 and cn-northwest-1 , which use amazonaws.com.cn ). For such regions, attach with an explicit URI (with the correct host) together with AUTHORIZATION_TYPE 'sigv4' instead of using ENDPOINT_TYPE . The warehouse identifier (the first argument to...weedfs_secret ( TYPE iceberg, CLIENT_ID '⟨access_key⟩', CLIENT_SECRET '⟨secret_key⟩', OAUTH2_SERVER_URI 'http://⟨seaweedfs_host⟩:8181/v1/oauth/tokens' ); CREATE SECRET seaweedfs_storage ( TYPE s3, KEY_ID '⟨access_key⟩', SECRET '⟨secret_key⟩', ENDPOIN... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- MySQL Import 8696
- 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
...sql; 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 P...is a 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 t... - https://man.mtool.work/duckdb/2.0/guides/database_integration/mysql.html
- Amazon RDS with IAM Authentication 8402
- Managed PostgreSQL databases on Amazon RDS and Aurora can authenticate with short-lived IAM tokens instead of a static password. DuckDB supports this through the postgres and aws extensions: the aws extension generates the token from an AWS
...ET aws_rds_secret ( TYPE rds, PROVIDER credential_chain, CHAIN 'env;sso', REGION '⟨eu-west-1⟩', RDS_USER '⟨postgres⟩', RDS_HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', RDS_PORT '5432' ); Then create a secret of type postgres that refere...the token generated by the rds secret is used (and refreshed) automatically: CREATE SECRET pg_rds_secret ( TYPE postgres, HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', PORT '5432', USER '⟨postgres⟩', DATABASE '⟨postgres⟩', SSLMODE requi... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
DuckDB 2.0 Documentation / man.mtool.work