Results of 1 - 10 of about 21 for bind (0.005 sec.)
- Table Functions 14139
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...kdb_table_function table_function , void * extra_info , duckdb_delete_callback_t destroy ); void duckdb_table_function_set_bind ( duckdb_table_function table_function , duckdb_table_function_bind_t bind ); void duckdb_table_function_set_init ( duckdb...); duckdb_state duckdb_register_table_function ( duckdb_connection con , duckdb_table_function function ); Table Function Bind void * duckdb_bind_get_extra_info ( duckdb_bind_info info ); void duckdb_table_function_get_client_context ( duckdb_bind_i...nfo info , duckdb_client_context * out_context ); void duckdb_bind_add_result_column ( duckdb_bind_info info , const char * name , duckdb_logical_type type ); idx_t duckdb_bind_get_paramete... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Complete API 12702
- 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
...pe duckdb_param_logical_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); duckdb_state duckdb_clear_bindings ( duckdb_prepared_statement prepared_statement ); duckdb_statement_type duckdb_prepared_statement_type ( duckdb_prepar...idx ); duckdb_type duckdb_prepared_statement_column_type ( duckdb_prepared_statement prepared_statement , idx_t col_idx ); Bind Values to Prepared Statements duckdb_state duckdb_bind_value ( duckdb_prepared_statement prepared_statement , idx_t param_...idx , duckdb_value val ); duckdb_state duckdb_bind_parameter_index ( duckdb_prepared_statement prepared_statement , idx_t * param_idx_out , const char * name ); duckdb_state... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Write User Defined Functions 9099
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
..., registered with register_table_function() and queried like any other table. VTab splits the work across three callbacks: bind runs once when the statement is prepared. It declares the result columns with add_result_column() and reads the call's arg...uments with get_parameter() , returning read-only bind data. init runs once before execution and returns per-scan state, such as a cursor. func produces one chunk of rows per ca...) function that returns one row per integer in 0..count , over columns of increasing complexity. Its skeleton, showing the bind data, init state, and per-chunk execution model: use duckdb::{ Connection, Result, core::{DataChunkHandle, LogicalTypeHand... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Prepared Statements 8778
- A prepared statement is a parameterized query. The query is prepared with question marks ( ? ) or dollar symbols ( $1 ) indicating the parameters of the query. Values can then be bound to these parameters, after which the prepared statement
...mes with different parameters. DuckDB supports prepared statements in the C API with the duckdb_prepare method. The duckdb_bind family of functions is used to supply values for subsequent execution of the prepared statement using duckdb_execute_prepa...result; if (duckdb_prepare(con, "INSERT INTO integers VALUES ($1, $2)", &stmt) == DuckDBError) { // handle error } duckdb_bind_int32(stmt, 1, 42); // the parameter index starts counting at 1! duckdb_bind_int32(stmt, 2, 43); // NULL as second paramet...statements if (duckdb_prepare(con, "SELECT * FROM integers WHERE i = ?", &stmt) == DuckDBError) { // handle error } duckdb_bind_int32(stmt, 1, 42); duckdb_execute_prepared(stmt, &result); // do something with result // clean up duckdb_destroy_result(... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- Write User Defined Functions 8778
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...e-use and finalized on register() (or close() ). The implementation is a DuckDBTableFunction with the following callbacks: bind runs when the statement is prepared. It registers the output columns with addResultColumn() and reads positional and named...call parameters with getParameter() and getNamedParameter() . It may return bind data that is passed to the later callbacks. init runs once before execution and returns the global state. localInit (optio...efault returns null . apply writes rows into the output vectors and returns the number of rows written, with access to the bind, global-init, and local-init data. The engine calls it repeatedly until it returns 0 . import java.sql.Connection; import... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- ODBC Extension 8355
- 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
...S VARCHAR2(3)) || CAST(? AS VARCHAR2(3)) FROM DUAL ', params = row(?, ?)) If we prepare this query with duckdb_prepare() , bind foo and bar VARCHAR values to it with duckdb_bind_value() and execute it with duckdb_execute_prepared() - the input parame...in remote DB every time duckdb_execute_prepared() is called. To avoid this problem is it possible to use 2-step parameter binding with params_handle named argument to odbc_query : -- create parameters handle SET VARIABLE params = odbc_create_params(...(? AS VARCHAR2(3)) || CAST(? AS VARCHAR2(3)) FROM DUAL ', params_handle = getvariable('params')); -- now we can repeatedly bind new parameters to the handle using 'odbc_bind_params()' -- and call 'duckdb_execute_prepared()' to run the prepared query... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Troubleshooting Quack 8084
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...he quack extension: FORCE INSTALL quack; ATTACH Fails to Bind a Remote Table Definition When a Quack client runs ATTACH 'quack:⟨host⟩' , it loads the server's table definitions up fron...t and binds them locally. A single definition that cannot be bound fails the entire attachment, even when you only intend to query un...tables are listed with a placeholder column of type UNKNOWN , which the client receives through duckdb_tables() and cannot bind: Catalog Error: Type with name UNKNOWN does not exist! The UNKNOWN type here is not the table's real type, and it does not... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- ODBC Extension Functions 8000
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...th odbc_connect Returns: Always returns NULL ( VARCHAR ). Example: SELECT odbc_begin_transaction(getvariable('conn')) odbc_bind_params odbc_bind_params(conn_handle BIGINT, params_handle BIGINT, params STRUCT) -> BIGINT Binds specified parameter value...s to the specified parameters handle. Only necessary with 2-step parameters binding, see Query parameters for details. Parameters: conn_handle ( BIGINT ): ODBC connection handle created with odbc_connect...ters values Returns: Parameters handle ( BIGINT ), the same one that was passed as a second argument. Example: SELECT odbc_bind_params(getvariable('conn'), getvariable('params1'), row(42, 'foo')) odbc_close odbc_close(conn_handle BIGINT) -> VARCHAR C... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Node.js Client (Neo) 7966
- 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
...gh-level API meant for applications. It depends on low-level bindings that adhere closely to DuckDB's C API , available separately as @duckdb/node-bindings . Roadmap Some features are not...yet complete: Binding and appending the MAP and UNION data types Appending default values row-by-row User-defined types & functions Profiling..., use extractStatements instead. Parameterize SQL const prepared = await connection.prepare('select $1, $2, $3'); prepared.bindVarchar(1, 'duck'); prepared.bindInteger(2, 42); prepared.bindList(3, listValue([10, 11, 12]), LIST(INTEGER)); const result... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- Quack Remote Protocol 7797
- 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
...with the -serve argument and connect to one with -connect . See Command Line Arguments . By default the server refuses to bind anything other than a local hostname. To listen on an externally-reachable address, pass allow_other_hostname = true : {:....certificate unless you pass ssl_cert_file and ssl_key_file (see the Reference ). For production deployments, we recommend binding the server to localhost and fronting it with a TLS-terminating reverse proxy. See Securing Quack with a Reverse Proxy ....a query table macro for ad-hoc SQL scoped to that attachment: {:.codebox-client} FROM remote_db.query('SELECT 42'); ATTACH binds the remote's table definitions on the client, so a single table definition that cannot be bound fails the whole attachmen... - https://man.mtool.work/duckdb/2.0/quack/overview.html
DuckDB 2.0 Documentation / man.mtool.work