⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 10 of about 10 for callback (0.004 sec.)
Replacement Scans 13872
The replacement scan API can be used to register a callback that is called when a table is read that does not exist in the catalog. For example, when a query such as SELECT * FROM my_table is executed and my_table does not exist, the replac ... ement scan callback will be called with my_table as parameter. The replacement scan can then insert a table function with a specific parameter ... e the read of the table. API Reference Overview void duckdb_add_replacement_scan ( duckdb_database db , duckdb_replacement_callback_t replacement , void * extra_data , duckdb_delete_callback_t delete_callback ); void duckdb_replacement_scan_set_function_ ... an definition to the specified database. Syntax void duckdb_add_replacement_scan ( duckdb_database db , duckdb_replacement_callback_t replacement , void * extra_data , duckdb_delete_callback_t delete_callback ); Parameters db : The database object to add ...
https://man.mtool.work/duckdb/2.0/clients/c/replacement_scans.html
Security 9296
This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que ... ilt-in defaults that are suitable for local development and single-user deployments, and each is exposed as an overridable callback for deployments with stricter requirements. Out of the box, they come with the following configuration: Authentication is ... erver URI or via the explicit TOKEN option in the ATTACH statement / quack_query function call. The default authentication callback compares the client-supplied token against the server's stored token. Authorization is permissive. The default authorizati ... on callback, quack_nop_authorization , returns the query text unchanged for every query. No further filtering happens. Both callbacks ...
https://man.mtool.work/duckdb/2.0/quack/security.html
Table Functions 9081
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_ ... pe ); void duckdb_table_function_set_extra_info ( duckdb_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 bin ... info info , const char * name ); void duckdb_bind_set_bind_data ( duckdb_bind_info info , void * bind_data , duckdb_delete_callback_t destroy ); void duckdb_bind_set_cardinality ( duckdb_bind_info info , idx_t cardinality , bool is_exact ); void duckdb_b ... _data ( duckdb_init_info info ); void duckdb_init_set_init_data ( duckdb_init_info info , void * init_data , duckdb_delete_callback_t destroy ); idx_t duckdb_init_get_column_count ( duckdb_init_info info ); idx_t duckdb_init_get_column_index ( duckdb_ini ...
https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
Write User Defined Functions 9081
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 ... r of arguments, call withVarArgs() to declare the element type and withVarArgsFunction() to supply the implementation. The callback receives the variadic arguments as an Object[] . withVarArgs() has to be set before withVarArgsFunction() , and the object ... , 3, 4); NULL Handling By default, a scalar function is called for every input row, including rows that contain SQL NULL : Callbacks that take Object arguments ( Function , BiFunction , and the varargs form) receive null for a NULL input and may return n ... ull to produce a NULL result. The primitive callbacks ( withIntFunction() , withLongFunction() , and withDoubleFunction() ) are never handed a null . When DuckDB passes a NULL ...
https://man.mtool.work/duckdb/2.0/clients/java/functions.html
Write User Defined Functions 9028
Overview The Go client can register user-defined functions written in Go: scalar functions that map input rows to a single output value, and table functions that produce a set of rows. It can also register a replacement scan that rewrites a ... ) and the composite constructors such as duckdb.NewListInfo() . Executor() returns a duckdb.ScalarFuncExecutor holding the callback. The simplest form is RowExecutor , a func(values []driver.Value) (any, error) called once per row. Register an instance o ... ther with duckdb.RegisterScalarUDFSet() : check(duckdb.RegisterScalarUDFSet(conn, "my_length", varcharUDF, listUDF)) For a callback that processes a whole data chunk at once rather than a row at a time, set ChunkContextExecutor in the executor instead of ... OM clause. It is described by a duckdb.RowTableFunction , whose Config declares the argument types and whose BindArguments callback is invoked once per call to bind the arguments and return a table source . The table source drives execution through its m ...
https://man.mtool.work/duckdb/2.0/clients/go/functions.html
Complete API 8402
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 ... ); void duckdb_scalar_function_set_extra_info ( duckdb_scalar_function scalar_function , void * extra_info , duckdb_delete_callback_t destroy ); void duckdb_scalar_function_set_bind ( duckdb_scalar_function scalar_function , duckdb_scalar_function_bind_t ... bind ); void duckdb_scalar_function_set_bind_data ( duckdb_bind_info info , void * bind_data , duckdb_delete_callback_t destroy ); void duckdb_scalar_function_set_bind_data_copy ( duckdb_bind_info info , duckdb_copy_callback_t copy ); void ... uckdb_aggregate_function_set_extra_info ( duckdb_aggregate_function aggregate_function , void * extra_info , duckdb_delete_callback_t destroy ); void * duckdb_aggregate_function_get_extra_info ( duckdb_function_info info ); void duckdb_aggregate_function ...
https://man.mtool.work/duckdb/2.0/clients/c/api.html
Connect 8152
Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi ... eate a Connector with duckdb.NewConnector() and open the database with sql.OpenDB() . The connector's second argument is a callback that runs against each new connection, which is where boot queries belong: connector, err := duckdb.NewConnector("/path/to ... l }) if err != nil { log.Fatal(err) } defer connector.Close() db := sql.OpenDB(connector) defer db.Close() Pass nil as the callback when no initialization is needed. A Connector is also the entry point for the Appender and Arrow interfaces, which operate ... queries and read results. Configuration — the full list of DuckDB settings that can be passed in the DSN or the connector callback. Concurrency — how DuckDB handles multiple connections and threads. Troubleshoot — cgo, linking, and other build problems ...
https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
Reference 7562
This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s ... into a STRUCT(host, port, ipv6, ssl, url) entry. quack_check_token(sid, client_token, server_token) Default authentication callback, compares the client-supplied token against the server's stored token. quack_nop_authorization(sid, query) Default authori ... zation callback, always allows. quack_clear_cache() Clear the cache. This also forces the DuckDB client to refresh its catalog. ATTACH Opt ... lar DuckDB session / global options. Set with SET ⟨name⟩ = ⟨value⟩ or SET GLOBAL . Authentication / Authorization The auth callbacks are evaluated on a fresh server-side connection every time, so the two settings below are global-scoped ( SET GLOBAL ). A ...
https://man.mtool.work/duckdb/2.0/quack/reference.html
Profile and Monitor 7472
Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information ... age registered from Go. Register one on a Connector with duckdb.RegisterLogStorage() , giving it a name and a duckdb.LoggerCallbacks whose DefaultLoggerCallback receives each entry's level, type, and message: connector, err := duckdb.NewConnector("", nil ... ) check(err) defer connector.Close() err = duckdb.RegisterLogStorage(connector, "my_log_storage", duckdb.LoggerCallbacks{ DefaultLoggerCallback: func(level, logType, logMsg string) { log.Printf("[%s] %s: %s", level, logType, logMsg) }, }) che ... () in addition to selecting the storage with SET logging_storage . Once both are set, DuckDB forwards all log calls to the callback. Further Reading Profiling — DuckDB's query profiling output and the enable_profiling and tracked_metrics settings. Loggin ...
https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
Appender 7365
Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co ... clear() . Connections and Threads Concurrent calls on the same appender raise an exception rather than wait. Calls from a callback during a flush also raise an exception. Use a separate appender for each thread. You can append rows or call clear() while ...
https://man.mtool.work/duckdb/2.0/clients/python/appender.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work