Results of 1 - 10 of about 392 for duckDb (0.005 sec.)
- Complete API 6901
- 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
...not part of the v1.0 stable API, which contains methods that are available long-term. API Reference Overview Open Connect duckdb_instance_cache duckdb_create_instance_cache (); duckdb_state duckdb_get_or_create_from_cache ( duckdb_instance_cache insta...nce_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 * out_database ); duckdb_state duckdb_open_ext ( const char * path... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Types 6901
- 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. DuckDB
...TEGER[] ). It is also possible to define types as arbitrary structs ( ROW(i INTEGER, j VARCHAR) ). For that reason, native DuckDB type objects are not mere enums, but a class that can potentially be nested. Types in the C API are modeled using an enum...( duckdb_type ) and a complex class ( duckdb_logical_type ). For most primitive types, e.g., integers or varchars, the enum is suff...icient. For more complex types, such as lists, structs or decimals, the logical type must be used. typedef enum DUCKDB_TYPE { DUCKDB_TYPE_INVALID = 0, DUCKDB_TYPE_BOOLEAN = 1, DUCKDB_TYPE_TINYINT = 2, DUCKDB_TYPE_SMALLINT = 3, DUCKDB_TYPE_IN... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Values 6901
- 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
...ar * text , idx_t length ); duckdb_value duckdb_create_bool ( bool input ); duckdb_value duckdb_create_int8 ( int8_t input ); duckdb_value duckdb_create_uint...8 ( uint8_t input ); duckdb_value duckdb_create_int16 ( int16_t input ); duckdb_value duckdb_create_uint16 ( uint16_t input ); duckdb_value duckdb_cre...ate_int32 ( int32_t input ); duckdb_value duckdb_create_uint32 ( uint32_t input ); duckdb_value duckdb_create_uint64 ( uint64_t input ); duckdb_value duckdb_c... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Appender 6884
- 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
...s are made in row-wise format. For every column, a duckdb_append_[type] call should be made, after which the row should be finished by calling duckdb_appender_end_row . After all r...ows have been appended, duckdb_appender_destroy should be used to finalize the appender and clean up the resulting memory. Note that duckdb_appender_dest...roy should always be called on the resulting appender, even if the function returns DuckDBError . Example duckdb_query(con, "CREATE TABLE people (id INTEGER, name VARCHAR)", NULL); duckdb_appender appender; if (du... - https://man.mtool.work/duckdb/2.0/clients/c/appender.html
- Vectors 6538
- 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
...d data chunk interfaces are the most efficient way of interacting with DuckDB, allowing for the highest performance. However, the interfaces are also difficult to use and care must be taken when using...them. Vector Format Vectors are arrays of a specific data type. The logical type of a vector can be obtained using duckdb_vector_get_column_type . The type id of the logical type can then be obtained using duckdb_get_type_id . Vectors themselve...s do not have sizes. Instead, the parent data chunk has a size (that can be obtained through duckdb_data_chunk_get_size ). All vectors that belong to a data chunk have the same size. Primitive Types For primitive types, th... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Table Functions 6461
- 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_
...function ( duckdb_table_function * table_function ); void duckdb_table_function_set_name ( duckdb_table_function table_function , const char...* name ); void duckdb_table_function_add_parameter ( duckdb_table_function table_function , duckdb_logical_type type ); void duckdb_table_functi...on_add_named_parameter ( duckdb_table_function table_function , const char * name , duckdb_logical_type type ); void duckdb_table_function_set_extra_info... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Startup & Shutdown 6331
- 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
...e that for an in-memory database no data is persisted to disk (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 th...ying. It is therefore 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_disconnect() and the duckdb_database has to be explicitly clos...ed with duckdb_close() to avoid memory and file handle leaking. Example duckdb_database db; duckdb_connection con; if (duckdb_open(NULL,... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Query 6323
- 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 variety of methods. The duckdb_column_count can be used to extract the number of columns. duckdb_column_name and duckdb_column_type can be used to extrac...t the names and types of individual columns. Example duckdb_state state; duckdb_result result; // create a table state = duckdb_query(con, "CREATE TABLE integers (i INTEGER, j INTEGE... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
- DuckDB Installation 6279
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...mentation page curl https://install.duckdb.org | bash Direct Download duckdb-cli-osx-universal.tar.gz SHA256: 8a8f67e7c7f7d1392fa63ba3971948391392fe2a25fca63e7008e33...c50beb4c2 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 curl https://install.duckdb.org | bash Direct Downloads duckdb-cli-linux-amd64.tar.gz SHA256: c6507206baf779...3c6013dbd82368469a45f20dc0e17a6f92f204602f652ed2bc duckdb-cli-linux-arm64.tar.gz SHA256: 859e1875d2a9515fbb4bf8871061437a14af82320da68c753f094c4b776348fe Docker Image docker run --... - https://man.mtool.work/duckdb/2.0/installation.html
- DuckDB Installation 6279
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...mentation page curl https://install.duckdb.org | bash Direct Download duckdb-cli-osx-universal.tar.gz SHA256: 8a8f67e7c7f7d1392fa63ba3971948391392fe2a25fca63e7008e33...c50beb4c2 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 curl https://install.duckdb.org | bash Direct Downloads duckdb-cli-linux-amd64.tar.gz SHA256: c6507206baf779...3c6013dbd82368469a45f20dc0e17a6f92f204602f652ed2bc duckdb-cli-linux-arm64.tar.gz SHA256: 859e1875d2a9515fbb4bf8871061437a14af82320da68c753f094c4b776348fe Docker Image docker run --... - https://man.mtool.work/duckdb/2.0/installation/
DuckDB 2.0 Documentation / man.mtool.work