Results of 1 - 10 of about 11 for disconnect (0.003 sec.)
- CONNECT and DISCONNECT Statements 14172
- New Support for the CONNECT and DISCONNECT statements was introduced in DuckDB 2.0. The CONNECT statement routes the current session to a remote database, so that subsequent queries execute on that remote and their results stream back. DISCONNECT
...h to it and route queries there. Examples Attach a remote DuckDB server over the Quack protocol , route queries to it, and disconnect again: ATTACH 'quack:server.example.com' AS qk (TOKEN '⟨my_token⟩'); CONNECT qk; SELECT count(*) FROM events; -- executes...on the server, results stream back DISCONNECT; Connect directly to a remote database using a connection string. For databases other than DuckDB, the connection string m...ion string ): CONNECT 'postgres:dbname=mydb host=localhost'; SELECT count(*) FROM orders; -- runs on the PostgreSQL server DISCONNECT; Syntax CONNECT { ⟨attached_database⟩ | '⟨connection_string⟩' }; DISCONNECT; CONNECT accepts either the alias of a databas... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- Startup & Shutdown 9957
- 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
...h thread uses its own connection to allow for the best parallel performance. All duckdb_connection s have to explicitly be disconnected with duckdb_disconnect() and the duckdb_database has to be explicitly closed with duckdb_close() to avoid memory and fil...) { // handle error } if (duckdb_connect(db, &con) == DuckDBError) { // handle error } // run queries... // cleanup duckdb_disconnect(&con); duckdb_close(&db); API Reference Overview duckdb_instance_cache duckdb_create_instance_cache (); duckdb_state duckd...db_connection connection ); duckdb_query_progress_type duckdb_query_progress ( duckdb_connection connection ); void duckdb_disconnect ( duckdb_connection * connection ); void duckdb_connection_get_client_context ( duckdb_connection connection , duckdb_clie... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Quack Remote Protocol 8784
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...y to work with a remote Quack database: you write plain SQL without qualifying every table name with the attached catalog. DISCONNECT returns the session to the local database. {:.codebox-client} ATTACH 'quack:server.example.com' AS qk (TOKEN '⟨MY_QUACK_TO...KEN_01234567890ABCDEF⟩'); CONNECT qk; SELECT count(*) FROM events; -- executes on the server, results stream back DISCONNECT; CONNECT is not specific to Quack: it points the session at any remote database that supports remote execution. See the CO...NNECT and DISCONNECT statements page for details. Authentication Clients pass the authentication token to the server in one of two ways: a quac... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- What's New in the Docs for 2.0 8641
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...ckDB 2.0 ships a polished version of the quack extension, which provides the remote protocol, and adds the new CONNECT and DISCONNECT statements to open and close connections from SQL. The command line client can start a server and attach to one directly....Quack extension CONNECT and DISCONNECT statements CLI -serve and -connect arguments Securing Quack with a reverse proxy Remote pushdown to PostgreSQL and MySQL V... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Vectors 8499
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...ow]); } else { printf("NULL\n"); } } duckdb_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); Example: Reading a String Vector duckdb_database db; duckdb_connection con; duckdb_open(nullptr,...r); } } else { printf("NULL\n"); } } duckdb_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); Example: Reading a Struct Vector duckdb_database db; duckdb_connection con; duckdb_open(nullptr,...col2_data[row]); } printf("}\n"); } duckdb_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); Example: Reading a List Vector duckdb_database db; duckdb_connection con; duckdb_open(nullptr, &... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- ODBC 101: A Duck Themed Guide to ODBC 8197
- What is ODBC? ODBC which stands for Open Database Connectivity, is a standard that allows different programs to talk to different databases including, of course, DuckDB. This makes it easier to build programs that work with many different d
...ional queries and perform other database operations such as inserting, updating, or deleting data. 6. Free the Handles and Disconnecting Finally, we need to free the handles and disconnect from the database. First, we need to free the statement handle: SQL...FreeHandle(SQL_HANDLE_STMT, stmt); Then we need to disconnect from the database: SQLDisconnect(dbc); And finally, we need to free the connection handle and the environment handle: SQLF...and environment handles can only be done after the connection to the database has been closed. Trying to free them before disconnecting from the database will result in an error. Sample Application The following is a sample application that includes a cpp... - https://man.mtool.work/duckdb/2.0/guides/odbc/general.html
- Node.js Client (Neo) 7984
- 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
...stance = 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 dropped, but you can also disconnect explicit...ly if and when you want: connection.disconnectSync(); or, equivalently: connection.closeSync(); Run SQL const result = await connection.run('from test_all_types()'); The... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- Complete API 7912
- 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
...db_connection connection ); duckdb_query_progress_type duckdb_query_progress ( duckdb_connection connection ); void duckdb_disconnect ( duckdb_connection * connection ); void duckdb_connection_get_client_context ( duckdb_connection connection , duckdb_clie..., and store transactional state associated with the connection. The instantiated connection should be closed using 'duckdb_disconnect'. Syntax duckdb_state duckdb_connect ( duckdb_database database , duckdb_connection * out_connection ); Parameters databas...on ); Parameters connection : The working connection Return Value -1 if no progress or a percentage of the progress duckdb_disconnect Closes the specified connection and de-allocates all memory allocated for that connection. Syntax void duckdb_disconnect (... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- MySQL Extension 7912
- 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.
...ted, the remote pushdown optimizer ships queries directly to the MySQL server instead of pulling tables over the wire, and DISCONNECT returns the session to the local database. Settings Name Description Default mysql_bit1_as_boolean Whether or not to conve... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Query 7841
- The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the application is not inter
...{ printf("NULL"); } printf("\n"); } duckdb_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); This prints the following result: 3,4 5,6 7,NULL duckdb_value Deprecated The duckdb_value functi... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
DuckDB 2.0 Documentation / man.mtool.work