Results of 1 - 10 of about 16 for destroy (0.007 sec.)
- Complete API 12615
- 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
...tance_cache , const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); duckdb_state duckdb_open ( const char * path , duckdb_database...ptions * out_arrow_options ); idx_t duckdb_client_context_get_connection_id ( duckdb_client_context context ); void duckdb_destroy_client_context ( duckdb_client_context * context ); void duckdb_destroy_arrow_options ( duckdb_arrow_options * arrow_optio...cription ); duckdb_state duckdb_set_config ( duckdb_config config , const char * name , const char * option ); void duckdb_destroy_config ( duckdb_config * config ); Error Data duckdb_error_data duckdb_create_error_data ( duckdb_error_type type , const... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Values 11575
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
...duckdb_get_struct_child ( duckdb_value value , idx_t index ); char * duckdb_value_to_string ( duckdb_value value ); duckdb_destroy_value Destroys the value and de-allocates all memory allocated for that type. Syntax void duckdb_destroy_value ( duckdb_va...lue * value ); Parameters value : The value to destroy. duckdb_create_varchar Creates a value from a null-terminated string Syntax duckdb_value duckdb_create_varchar ( const cha...r * text ); Parameters text : The null-terminated string Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_varchar_length Creates a value from a string Syntax duckdb_value duckdb_create... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Table Functions 10206
- 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_
...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 bind ); void...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_bind_set_er...kdb_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_init_info inf... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Startup & Shutdown 9704
- 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
...tance_cache , const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); duckdb_state duckdb_open ( const char * path , duckdb_database...ptions * out_arrow_options ); idx_t duckdb_client_context_get_connection_id ( duckdb_client_context context ); void duckdb_destroy_client_context ( duckdb_client_context * context ); void duckdb_destroy_arrow_options ( duckdb_arrow_options * arrow_optio...ance cache is necessary if a client/program (re)opens multiple databases to the same file within the same process. Must be destroyed with 'duckdb_destroy_instance_cache'. Return Value The database instance cache. Syntax duckdb_instance_cache duckdb_crea... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Types 9322
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
..., idx_t index ); duckdb_logical_type duckdb_union_type_member_type ( duckdb_logical_type type , idx_t index ); void duckdb_destroy_logical_type ( duckdb_logical_type * type ); duckdb_state duckdb_register_logical_type ( duckdb_connection con , duckdb_lo...chunk from the duckdb_result. This function should be called repeatedly until the result is exhausted. The result must be destroyed with duckdb_destroy_data_chunk . This function supersedes all duckdb_value functions, as well as the duckdb_column_data...lement. duckdb_create_logical_type Creates a duckdb_logical_type from a primitive type. The resulting logical type must be destroyed with duckdb_destroy_logical_type . Returns an invalid logical type, if type is: DUCKDB_TYPE_INVALID , DUCKDB_TYPE_DECIMA... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Appender 9114
- Appenders are the most efficient way of loading data into DuckDB from within the C interface, and are recommended for fast data loading. The appender is much faster than using prepared statements or individual INSERT INTO statements. Append
...r which the row should be finished by calling duckdb_appender_end_row . After all rows have been appended, duckdb_appender_destroy should be used to finalize the appender and clean up the resulting memory. Note that duckdb_appender_destroy should always...der, "Hannes"); duckdb_appender_end_row(appender); // finish appending and flush all the rows to the table duckdb_appender_destroy(&appender); API Reference Overview duckdb_state duckdb_appender_create ( duckdb_connection connection , const char * schem...duckdb_appender appender ); duckdb_state duckdb_appender_close ( duckdb_appender appender ); duckdb_state duckdb_appender_destroy ( duckdb_appender * appender ); duckdb_state duckdb_appender_add_column ( duckdb_appender appender , const char * name );... - https://man.mtool.work/duckdb/2.0/clients/c/appender.html
- Prepared Statements 9028
- 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
...tement using duckdb_execute_prepared . After we are done with the prepared statement it can be cleaned up using the duckdb_destroy_prepare method. Example duckdb_prepared_statement stmt; duckdb_result result; if (duckdb_prepare(con, "INSERT INTO integer...t32(stmt, 2, 43); // NULL as second parameter means no result set is requested duckdb_execute_prepared(stmt, NULL); duckdb_destroy_prepare(&stmt); // we can also query result sets using prepared statements if (duckdb_prepare(con, "SELECT * FROM integers...r } duckdb_bind_int32(stmt, 1, 42); duckdb_execute_prepared(stmt, &result); // do something with result // clean up duckdb_destroy_result(&result); duckdb_destroy_prepare(&stmt); After calling duckdb_prepare , the prepared statement parameters can be in... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- Query 8750
- 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
...ested in the result set or if the query produces no result. After the result is consumed, the duckdb_destroy_result method should be used to clean up the result. Elements can be extracted from the duckdb_result object using a varie...uery(con, "SELECT * FROM integers", &result); if (state == DuckDBError) { // handle error } // handle the result // ... // destroy the result after we are done with it duckdb_destroy_result(&result); Value Extraction Values can be extracted using either...lidity_row_is_valid(col2_validity, row)) { printf("%d", col2_data[row]); } else { printf("NULL"); } printf("\n"); } duckdb_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); This prints th... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
- Configuration 8612
- Configuration options can be provided to change different settings of the database system. Note that many of these settings can be changed later on using PRAGMA statements as well. The configuration object should be created, filled with val
...f (duckdb_open_ext(NULL, &db, config, NULL) == DuckDBError) { // handle error } // cleanup the configuration object duckdb_destroy_config(&config); // run queries... // cleanup duckdb_close(&db); API Reference Overview duckdb_state duckdb_create_config...cription ); duckdb_state duckdb_set_config ( duckdb_config config , const char * name , const char * option ); void duckdb_destroy_config ( duckdb_config * config ); duckdb_create_config Initializes an empty configuration object that can be used to prov...ide start-up options for the DuckDB instance through duckdb_open_ext . The duckdb_config must be destroyed using 'duckdb_destroy_config' This will always succeed unless there is a malloc failure. Note that duckdb_destroy_config... - https://man.mtool.work/duckdb/2.0/clients/c/config.html
- Vectors 7988
- 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
...b_validity_row_is_valid(vector_validity, row)) { printf("%lld\n", vector_data[row]); } else { printf("NULL\n"); } } duckdb_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); Example: Readi...string pointer printf("%.*s\n", str.value.pointer.length, str.value.pointer.ptr); } } else { printf("NULL\n"); } } duckdb_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); Example: Readi...(col2_validity, row)) { // col2 is NULL printf("NULL"); } else { printf("%lld", col2_data[row]); } printf("}\n"); } duckdb_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); Example: Readi... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
DuckDB 2.0 Documentation / man.mtool.work