Results of 1 - 10 of about 43 for Manager (0.001 sec.)
- ODBC API on Linux 13636
- Driver Manager A driver manager is required to manage communication between applications and the ODBC driver. We tested and support unixODBC that is a complete ODBC driver manager for Linux. Users can install it from the command line: On De
...i files. These files can be placed to the user home directory /home/⟨username⟩ or in the system /etc directory. The Driver Manager prioritizes the user configuration files over the system files. For the details of the configuration parameters, see the O... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- ODBC API Overview 10720
- Installation To use the DuckDB ODBC client, visit the ODBC installation page . The latest stable version of the DuckDB ODBC client is 2.0.0. This page describes the DuckDB ODBC driver, which lets other applications connect to DuckDB . To co
...API that provides access to different flavors of Database Management Systems (DBMSs). The ODBC API consists of the Driver Manager (DM) and the ODBC drivers. The Driver Manager is part of the system library, e.g., unixODBC, which manages the communicati... - https://man.mtool.work/duckdb/2.0/clients/odbc/overview.html
- Pragmas 10273
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...ocks in the database wal_size VARCHAR, -- write ahead log size memory_usage VARCHAR, -- memory used by the database buffer manager memory_limit VARCHAR -- maximum memory allowed for the database Storage Information To get storage information: PRAGMA sto...the SHOW DATABASES statement : PRAGMA show_databases; Resource Management Memory Limit Set the memory limit for the buffer manager: SET memory_limit = '1GB'; The memory limit can also be specified as a percentage of the total system memory: SET memory_l...at cannot be parsed as a valid percentage raise an error. Warning The specified memory limit is only applied to the buffer manager. For most queries, the buffer manager handles the majority of the data processed. However, certain in-memory data structur... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- ODBC API on macOS 9810
- A driver manager is required to manage communication between applications and the ODBC driver. DuckDB supports unixODBC , which is a complete ODBC driver manager for macOS and Linux. Users can install it from the command line via Homebrew :
... - https://man.mtool.work/duckdb/2.0/clients/odbc/macos.html
- Connect 9810
- Overview Every DuckDB feature reachable from Rust starts with a Connection . Opening in-memory and file-backed databases, configuring a database instance with Config , opening read-only, pooling connections across threads, the crate's threa
...nd a connection to each worker thread, the r2d2 feature integrates DuckDB with the r2d2 connection pool. A DuckdbConnectionManager creates connections that the pool checks out and returns: use duckdb::{params, DuckdbConnectionManager}; let manager = Duc...kdbConnectionManager::file("my_database.duckdb")?; let pool = r2d2::Pool::new(manager)?; // Each worker checks out its own connection from the...pool. let conn = pool.get()?; conn.execute("INSERT INTO foo (bar) VALUES (?)", params![1])?; DuckdbConnectionManager::memory() builds a manager for an in-memory database, and DuckdbConnectionManager::file_with_flags() and memory_with_flags... - https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
- ODBC Extension 9594
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...is also available under the alias odbc . Installing and Loading On Linux and macOS the extension requires unixODBC driver manager to be installed. See below for installation instructions. The extension can be installed automatically, but needs to be lo...lickHouse: basic types covered Spark: basic types covered Arrow Flight SQL: basic types covered Installing unixODBC Driver Manager on Linux or macOS On Linux unixODBC can be installed using the system package manager. Depending on the Linux distribution...ora: sudo dnf install unixODBC Alpine: sudo apk add unixodbc On macOS unixODBC can be installed using the Homebrew package manager : brew install unixodbc To use legacy x86_64 ODBC drivers under the Rosetta translator, the unixODBC must be installed usi... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- CREATE SECRET Statement 9147
- The CREATE SECRET statement creates a new secret in the Secrets Manager . Syntax for CREATE SECRET Warning When using the command line client , the CREATE SECRET statements are stored in your DuckDB history as plain text. Syntax for DROP SE
... - https://man.mtool.work/duckdb/2.0/sql/statements/create_secret.html
- DBeaver SQL IDE 8916
- 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
...ernatively, you can access the driver settings menu by returning to the main DBeaver window and clicking Database > Driver Manager in the menu bar. Then select DuckDB, then click Edit. Go to the “Libraries” tab, then click on the DuckDB driver and click...db_jdbc artifact on Maven Central and download the .jar file for the version you want. In DBeaver, go to Database > Driver Manager, select DuckDB, and click “Edit”. On the “Libraries” tab, click “Add File” and select the .jar file you downloaded. Remove... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
- ODBC API on Windows 8700
- Setup Using the DuckDB ODBC API on Windows requires the following steps: Microsoft Windows requires an ODBC Driver Manager to manage communication between applications and the ODBC drivers. The Driver Manager on Windows is provided in a DLL
... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- HTTP(S) Support 8700
- 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
...ain.tld/file2.parquet' ]); Authenticating To authenticate for an HTTP(S) endpoint, create an HTTP secret using the Secrets Manager : CREATE SECRET http_auth ( TYPE http, BEARER_TOKEN '⟨token⟩' ); Or: CREATE SECRET http_auth ( TYPE http, EXTRA_HTTP_HEADE...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_PASSWO... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
DuckDB 2.0 Documentation / man.mtool.work