Results of 1 - 10 of about 18 for Instances (0.002 sec.)
- Connect 14464
- 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
...r a file-backed connection, duplicate() is effectively the same as opening a new connection on the same URL, because those instances are shared through the instance cache anyway. Multiple connections to the same instance are allowed, but they must all be...opened with the same options. Options are applied when the instance starts, as the first connection is opened, so a later connection that requests different options — a different access_mode..., for example — is rejected. See Database Instances and Instance Caching . JDBC URL Syntax A DuckDB JDBC URL consists of the jdbc:duckdb: prefix, an optional database name, a... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- SQL on Pandas 10089
- Pandas DataFrames stored in local variables can be queried as if they are regular tables within DuckDB. import duckdb import pandas # Create a Pandas dataframe my_df = pandas.DataFrame.from_dict({'a': [42]}) # query the Pandas DataFrame "my
...df() The seamless integration of Pandas DataFrames into DuckDB SQL queries is allowed by replacement scans , which replace instances of accessing the my_df table (which does not exist in DuckDB) with a table function that reads the my_df dataframe.... - https://man.mtool.work/duckdb/2.0/guides/python/sql_on_pandas.html
- C++ API 9814
- 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
...nd the abstractions of a database instance ( DuckDB class), multiple Connection s to the database instance and QueryResult instances as the result of queries. The header file for the C++ API is duckdb.hpp . Startup & Shutdown To use DuckDB, you must first...xceptions, 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-safe, they will be locked during querying. It is th... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Secrets Manager 9814
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...temporary or persistent . Temporary secrets are used by default – and are stored in-memory for the life span of the DuckDB instance similar to how settings worked previously. Persistent secrets are stored in unencrypted binary format in the ~/.duckdb/stor...icitly use the default CONFIG secret provider here. Persistent Secrets In order to persist secrets between DuckDB database instances, we can now use the CREATE PERSISTENT SECRET command, e.g.: CREATE PERSISTENT SECRET my_persistent_secret ( TYPE s3, KEY_I...to/my_secrets_dir'; The secret_directory setting applies to the current DuckDB instance and is not persisted across DuckDB instances. If you use a custom secrets directory, set secret_directory again when starting a new DuckDB instance before creating or... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- Time Types 9265
- The TIME and TIMETZ types specify the hour, minute, second, microsecond of a day. Name Aliases Description TIME TIME WITHOUT TIME ZONE Time of day TIMETZ TIME WITH TIME ZONE Time of day, with time zone offset TIME_NS Time of day, nanosecond
...precision Instances can be created using the type names as a keyword, where the data must be formatted according to the ISO 8601 format ( hh:m... - https://man.mtool.work/duckdb/2.0/sql/data_types/time.html
- SET and RESET Statements 8990
- 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
...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 closed and a new instance is started, configuration options use their defaults unle... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- Concurrency 8716
- Handling Concurrency Single Process In in-process mode, DuckDB has two configurable options for concurrency: Read-write mode: one process can both read and write to the database. Read-only mode: multiple processes can read from the database
...the DuckLake format with PostgreSQL as the catalog database . By coordinating through a central PostgreSQL catalog, DuckDB instances can achieve concurrent read-writes on the same database. DuckLake 1.1 , intended for production use, was released alongsid... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
- Array Type 8167
- An ARRAY column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including ARRAY , LIST
...pute cosine similarity: SELECT array_cosine_similarity(x.v, y.v) FROM x, y WHERE x.i = y.i; Ordering The ordering of ARRAY instances is defined using a lexicographical order. NULL values compare greater than all other values and are considered equal to ea... - https://man.mtool.work/duckdb/2.0/sql/data_types/array.html
- Node.js Client (Neo) 7635
- 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
...i'; 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 in...guration options : const instance = await DuckDBInstance.create('my_duckdb.db', { threads: '4' }); Instance Cache Multiple instances in the same process should not attach the same database. To prevent this, an instance cache can be used: const instance =... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- PostgreSQL Extension and the Secret Manager 7635
- 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
...across sessions. Managing Multiple Secrets Named secrets can be used to manage connections to multiple PostgreSQL database instances. Secrets can be given a name upon creation. CREATE SECRET postgres_secret_one ( TYPE postgres, HOST '127.0.0.1', PORT 5432... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
DuckDB 2.0 Documentation / man.mtool.work