Results of 1 - 10 of about 67 for Instance (0.005 sec.)
- Connect 13728
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...) an underlying database instance, how DuckDB's threads relate to that instance, how to open or attach a DuckLake , and how to reach a remote DuckDB server...be created using the DriverManager . The DuckDBConnection#duplicate() method opens another connection to the same database instance without re-reading the configuration: DuckDBConnection conn2 = ((DuckDBConnection) conn).duplicate(); Its main purpose is...to reach a connection-private in-memory database instance — the one created by the plain jdbc:duckdb: URL — which no other URL can address. On a named in-memory or a file-backed co... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Startup & Shutdown 13187
- To use DuckDB, you must first initialize a duckdb_database handle using duckdb_open() . duckdb_open() takes as parameter the database file to read and write from. The special value NULL ( nullptr ) can be used to create an in-memory databas
...{ // handle error } // run queries... // cleanup duckdb_disconnect(&con); duckdb_close(&db); API Reference Overview duckdb_instance_cache duckdb_create_instance_cache (); duckdb_state duckdb_get_or_create_from_cache ( duckdb_instance_cache instance_cache..., const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); duckdb_state duckdb_open ( const char * path , duckdb_database * out_dat...duckdb_value duckdb_get_table_names ( duckdb_connection connection , const char * query , bool qualified ); duckdb_create_instance_cache Creates a new database instance cache. The instance cache is necessary if a client/program (re)opens multiple databa... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Profile and Monitor 9944
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...nitoring is opt-in per connection: set the jdbc_jfr_memory_monitor property to an identifier for the connection's database instance. The value is an arbitrary label that is attached to every event as its component field, so that operators can attribute m...tag String DuckDB memory tag, such as BASE_TABLE , HASH_TABLE , or ALLOCATOR . dbAddress long Native address of the DuckDB instance, a stable per-instance identifier. memoryUsageBytes long Bytes currently allocated for this tag. temporaryStorageBytes lon...d fields are also present. Stack traces are disabled for this event. Attribution The monitor is keyed on the native DuckDB instance address, the dbAddress field, not on the JDBC connection. There is one sample stream per distinct instance, so shared memo... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Deploying Quack 9830
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...Formation template maintained alongside the extension. It provisions a small EC2 instance running DuckDB, the quack extension behind nginx and Let's Encrypt TLS. As its output, it surfaces the per-instance token...OMPLETE . Open the stack's Outputs tab. Click the ConnectURL value to open a shell.duckdb.org session pre-wired to the new instance, or copy QuackURI and Token to connect from a local DuckDB session (see below). The stack defaults to a t3.micro instance;...s = 8'); FROM quack_query_by_name('remote', 'SELECT current_setting(''threads'')'); Tearing Down When you're done with the instance, delete the stack: aws cloudformation delete-stack --stack-name quack-demo --region us-east-1 Or use the Delete button in... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- SET and RESET Statements 9673
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...Configuration options can have different scopes: GLOBAL : Configuration value is used (or reset) across the entire DuckDB instance. SESSION : Configuration value is used (or reset) only for the current session attached to a DuckDB instance. LOCAL : Not...scope for the configuration option is used. For most options this is GLOBAL . GLOBAL settings apply to the current DuckDB instance. They are not written to the database file or persisted across DuckDB instances. If all connections to an instance are clo...sed and a new instance is started, configuration options use their defaults unless they are set again. For example, in DuckDB 2.0 the TimeZone op... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- DuckDB_% Metadata Functions 9147
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...metrics. VARCHAR duckdb_columns The duckdb_columns() function provides metadata about the columns available in the DuckDB instance. Column Description Type database_name The name of the database that contains the column object. VARCHAR database_oid Inte...ns() ) duckdb_connection_count The duckdb_connection_count() function returns the number of open connections to the DuckDB instance. Column Description Type count The number of open connections. UBIGINT duckdb_constraints The duckdb_constraints() functio...n provides metadata about the constraints available in the DuckDB instance. Column Description Type database_name The name of the database that contains the constraint. VARCHAR database_oid Interna... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- C++ API 8606
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...a C++17 compiler . Basic API Usage DuckDB implements a custom C++ API. This is built around the abstractions of a database instance ( DuckDB class), multiple Connection s to the database instance and QueryResult instances as the result of queries. The he...ader file for the C++ API is duckdb.hpp . Startup & Shutdown To use DuckDB, you must first initialize a DuckDB instance using its constructor. DuckDB() takes as parameter the database file to read and write from. The special value nullptr can...emory limits. The DuckDB constructor may throw exceptions, for example if the database file is not usable. With the DuckDB instance, you can create one or many Connection instances using the Connection() constructor. While connections should be thread-sa... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Node.js Client (Neo) 8393
- Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi
...rt { DuckDBConnection } from '@duckdb/node-api'; const connection = await DuckDBConnection.create(); This uses the default instance. For advanced usage, you can create instances explicitly. Create Instance import { DuckDBInstance } from '@duckdb/node-api...'; Create with an in-memory database: const instance = await DuckDBInstance.create(':memory:'); Equivalent to the above: const instance = await DuckDBInstance.create(); Read f...rom and write to a database file, which is created if needed: const instance = await DuckDBInstance.create('my_duckdb.db'); Set configuration options : const instance = await DuckDBInstance.create('m... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- Complete API 8180
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...rt of the v1.0 stable API, which contains methods that are available long-term. API Reference Overview Open Connect duckdb_instance_cache duckdb_create_instance_cache (); duckdb_state duckdb_get_or_create_from_cache ( duckdb_instance_cache instance_cache..., const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); duckdb_state duckdb_open ( const char * path , duckdb_database * out_dat...uckdb_expression_fold ( duckdb_client_context context , duckdb_expression expr , duckdb_value * out_value ); duckdb_create_instance_cache Creates a new database instance cache. The instance cache is necessary if a client/program (re)opens multiple databa... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- S3 and AWS Authentication 8023
- This page is the entry point for authenticating to S3 and other AWS services from DuckDB. Authentication is configured using secrets , and the detailed reference material lives on the S3 API Support and AWS Extension pages. The sections bel
...h IAM Roles for Service Accounts (IRSA) credential_chain with the web_identity chain Web Identity (IRSA) You run on an EC2 instance and want to use its instance profile credential_chain with the instance chain credential_chain provider You connect to Ama...der fetches credentials automatically using the AWS SDK, covering profiles, SSO, assumed roles, web identities (IRSA), and instance metadata. To use the AWS SDK default provider: CREATE OR REPLACE SECRET secret ( TYPE s3, PROVIDER credential_chain ); You... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
DuckDB 2.0 Documentation / man.mtool.work