Results of 1 - 10 of about 114 for Connection (0.006 sec.)
- Startup & Shutdown 10281
- 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
...isk (i.e., all data is lost when you exit the process). With the duckdb_database handle, you can create one or many duckdb_connection using duckdb_connect() . While individual connections are thread-safe, they will be locked during querying. It is therefor...e recommended that each thread uses its own connection to allow for the best parallel performance. All duckdb_connection s have to explicitly be disconnected with duckdb_disconn...as to be explicitly closed with duckdb_close() to avoid memory and file handle leaking. Example duckdb_database db; duckdb_connection con; if (duckdb_open(NULL, &db) == DuckDBError) { // handle error } if (duckdb_connect(db, &con) == DuckDBError) { // hand... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Connect 10168
- 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
...relate to that instance, how to open or attach a DuckLake , and how to reach a remote DuckDB server over Quack . Opening a Connection In JDBC, database connections are created through the standard java.sql.DriverManager class. On modern JVMs the driver reg...ed. If that does not happen for some reason, load the DuckDBDriver class explicitly to force registration before opening a connection: Class.forName("org.duckdb.DuckDBDriver"); Connection conn = DriverManager.getConnection("jdbc:duckdb:"); In GraalVM Nativ...xplicit load: the service-provider discovery is not reliably visible to Native Image's static analysis. To create a DuckDB connection, call DriverManager with the jdbc:duckdb: JDBC URL prefix, like so: import java.sql.Connection; import java.sql.DriverMana... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Connect 9488
- 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
...d-safety guarantees, and closing a connection are all covered below. Opening a Connection A Connection is created with Connection::open_in_memory() for an in-memory dat...abase, or Connection::open(path) for a database file. Both return a Result , so the ? operator propagates any error: use duckdb::{Connection, R...esult}; // In-memory database: nothing is persisted to disk. let conn = Connection::open_in_memory()?; // File-backed database: created if it does not exist. let conn = Connection::open("my_database.duckdb... - https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
- PostgreSQL Extension Connection Pool 9287
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...the number of the connections opened at the same time should not be too high To deal with these points the extensions uses an in-memory connection pool.... With it a limited number of connections are kept open (and idle) after use and can be reused for subsequent queries. Parallel Scans Due to DuckDB's multithreaded...query processing, postgres extension can open multiple connections even for queries that performs a scan for a single PostgreSQL table. The number of parallel queries running for a single... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- Node.js Client (Neo) 8972
- 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
...db/node-api'; console.log(duckdb.version()); console.log(duckdb.configurationOptionDescriptions()); Connect import { DuckDBConnection } from '@duckdb/node-api'; const connection = await DuckDBConnection.create(); This uses the default instance. For advance...e = new DuckDBInstanceCache(); const instance = await cache.getOrCreateInstance('my_duckdb.db'); Connect to Instance const connection = await instance.connect(); Disconnect Connections will be disconnected automatically soon after their reference is droppe...d, but you can also disconnect explicitly if and when you want: connection.disconnectSync(); or, equivalently: connection.closeSync(); Run SQL const result = await connection.run('from test_all_typ... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- Complete API 8909
- 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
...error ); void duckdb_close ( duckdb_database * database ); duckdb_state duckdb_connect ( duckdb_database database , duckdb_connection * out_connection ); void duckdb_interrupt ( duckdb_connection connection ); duckdb_query_progress_type duckdb_query_progre...ss ( duckdb_connection connection ); void duckdb_disconnect ( duckdb_connection * connection ); void duckdb_connection_get_client_context ( duckd...b_connection connection , duckdb_client_context * out_context ); void duckdb_connection_get_arrow_options ( duckdb_connection connectio... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Python DB API 8846
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
...represents a connection to a database. This is done through the duckdb.connect method, which takes three arguments: database , read_only and confi...argument can be used to provide a dict that contains key-value pairs referencing settings understood by DuckDB. In-Memory Connection The special value :memory: can be used to create an in-memory database . Note that for an in-memory database no data is pe...rsisted to disk (i.e., all data is lost when you exit the Python process). Named In-memory Connections The special value :memory: can also be postfixed with a name, for example: :memory:conn3 . When a name is provided, subse... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
- Python Client API 8846
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...the buffered rows flush ( self ) → None Apply the rows buffered since the last flush with one statement on the appender's connection class duckdb. DuckDBPyConnection Bases: object abort ( self ) → None Cancel the rest of the result of execute(); a stateme...fails an open transaction append ( self , table_name : str , df : object , * , by_name : bool = False ) → _duckdb.DuckDBPyConnection Append the passed DataFrame to the named table appender ( self , table : str , * , columns : list | None = None , action :...ype , size : int ) → _duckdb._sqltypes.DuckDBPyType Create an array type object of ‘type' begin ( self ) → _duckdb.DuckDBPyConnection Start a new transaction checkpoint ( self ) → _duckdb.DuckDBPyConnection Synchronizes data in the write-ahead log (WAL) to... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- PostgreSQL Extension Functions 8733
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...figure_pool FROM postgres_configure_pool([⟨optional named parameters⟩]) -> TABLE When a PostgreSQL database is attached, a connection pool is created for this database. This function allows to change the configuration options of a connection pool for the s...hed database. It also allows to list the current effective configuration options and the collected runtime statistics of a connection pool. Parameters catalog_name ( VARCHAR ): the name (alias) of the attached Postgres database to which pool the configurat...be specified and non-NULL when any other option is specified. acquire_mode ( VARCHAR , default: 'force' ): how to acquire connections from the pool: 'force' (always connect, ignore pool limit), 'wait' (block until available), 'try' (fail immediately if un... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Swift Client 8708
- DuckDB has a Swift client. See the announcement post for details. Instantiating DuckDB DuckDB supports both in-memory and persistent databases. To work with an in-memory database, run: let database = try Database(store: .inMemory) To work w
...ersistent database, run: let database = try Database(store: .file(at: "test.db")) Queries can be issued through a database connection. let connection = try database.connect() DuckDB supports multiple connections per database. Application Example The rest o...reating an Application-Specific Type We first create an application-specific type that we'll use to house our database and connection and through which we'll eventually define our app-specific queries. import DuckDB final class ExoplanetStore { let databas...e: Database let connection: Connection init(database: Database, connection: Connection) { self.database = database self.connection = connection } } L... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
DuckDB 2.0 Documentation / man.mtool.work