Results of 1 - 10 of about 217 for Type (0.005 sec.)
- Types 9844
- 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
...kDB also supports columns of composite types. For example, it is possible to define an array of integers ( INTEGER[] ). It is also possible to define types as arbitra...ry 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 ( duc...kdb_type ) and a complex class ( duckdb_logical_type ). For most primitive types, e.g., integers or varchars, the enum is sufficien... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Complete API 9194
- 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
...base , duckdb_connection * out_connection ); void duckdb_interrupt ( duckdb_connection connection ); duckdb_query_progress_type duckdb_query_progress ( duckdb_connection connection ); void duckdb_disconnect ( duckdb_connection * connection ); void du...oid duckdb_destroy_config ( duckdb_config * config ); Error Data duckdb_error_data duckdb_create_error_data ( duckdb_error_type type , const char * message ); void duckdb_destroy_error_data ( duckdb_error_data * error_data ); duckdb_error_type duckdb..._error_data_error_type ( duckdb_error_data error_data ); const char * duckdb_error_data_message ( duckdb_error_data error_data ); bool duckdb_err... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Types API 8439
- The DuckDBPyType class, duckdb.sqltypes.DuckDBPyType , represents one of the data types . Use DuckDBPyType to describe SQL types when declaring function parameters, return types or casts. Python types such as int are accepted too: int descr
...s BIGINT . Converting a data value such as 5 follows different rules; see Python Object Conversion . Converting from Other Types Wherever a DuckDBPyType is expected, any of the options listed below can be given instead. Python Built-Ins The table bel...ow shows the mapping of Python Built-in types to DuckDB type. Built-in types DuckDB type bool BOOLEAN bytearray BLOB bytes BLOB float DOUBLE int BIGINT str VARCHAR Num...Py Scalar Types The table below shows the mapping of NumPy scalar types to DuckDB type. A NumPy dtype object does not convert: DuckDBPyTy... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- PHP Client 8208
- The DuckDB PHP client is a tertiary client and is maintained by a third-party. Client API for PHP, focused on performance. The DuckDB PHP client uses the official C API internally through FFI , achieving good benchmark results. This library
...--------------------------------------------------------------------------------------------------- | column_name | column_type | min | max | approx_unique | avg | std | q25 | q50 | q75 | count | null_percentage | ------------------------------------...8.3. ext-ffi. Recommended ext-bcmath – Needed for big integers (> PHP_INT_MAX). ext-zend-opcache – For better performance. Type Support From version 1.2.0 on the library supports all DuckDB file types. DuckDB Type SQL Type PHP Type DUCKDB_TYPE_BOOLEA...N BOOLEAN bool DUCKDB_TYPE_TINYINT TINYINT int DUCKDB_TYPE_SMALLINT SMALLINT int DUCKDB_TYPE_INTEGER INTEGER int DUCKDB_TYPE_BIGINT BIGINT int DUCKDB... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php.html
- DuckDB_% Metadata Functions 7988
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...tion lists the metrics that can be collected by the profiler , e.g., using the tracked_metrics setting. Column Description Type metric_name The name of the metric, e.g., query.cpu_time . VARCHAR metric_type The type of the metric's value, e.g., doubl...mns The duckdb_columns() function provides metadata about the columns available in the DuckDB instance. Column Description Type database_name The name of the database that contains the column object. VARCHAR database_oid Internal identifier of the da...column is a generated column, the expression used to compute it; NULL otherwise. Available as of DuckDB 2.0. VARCHAR data_type The name of the column data type. VARCHAR data_type_id The internal identifier of the column data type. BIGINT character_m... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Prepared Statements 7831
- 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
...); After calling duckdb_prepare , the prepared statement parameters can be inspected using duckdb_nparams and duckdb_param_type . In case the prepare fails, the error can be obtained through duckdb_prepare_error . It is not required that the duckdb_b...ind family of functions matches the prepared statement parameter type exactly. The values will be auto-cast to the required value as required. For example, calling duckdb_bind_int8 on a parame...ter type of DUCKDB_TYPE_INTEGER will work as expected. Warning Do not use prepared statements to insert large amounts of data into... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- Query 7495
- 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
...ety 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 extract the names and types of individual columns. Example duckdb_state state; duckdb_result result; // cre...data chunks in DuckDB's native array format and can therefore be very fast. The duckdb_value functions perform bounds- and type-checking, and will automatically cast values to the desired type. This makes them more convenient and easier to use, at th...e expense of being slower. See the Types page for more information. For optimal performance, use duckdb_fetch_chunk to extract data from the query result. The duc... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
- CREATE TYPE Statement 7495
- The CREATE TYPE statement defines a new type in the catalog. Examples Create a simple ENUM type: CREATE TYPE mood AS ENUM ('happy', 'sad', 'curious'); Create a simple STRUCT type: CREATE TYPE many_things AS STRUCT(k INTEGER, l VARCHAR); Cre
...ate a simple UNION type: CREATE TYPE one_thing AS UNION(number INTEGER, string VARCHAR); Create a type alias: CREATE TYPE x_index AS INTEGER; Repl...ace an existing type: CREATE OR REPLACE TYPE mood AS ENUM ('cheerful', 'gloomy'); Syntax The CREATE TYPE clause defines a new data type availab...le to this DuckDB instance. Use the OR REPLACE modifier to redefine a type that already exists. These new types can then be inspected in the duckdb_types table . Limitations Extending types to supp... - https://man.mtool.work/duckdb/2.0/sql/statements/create_type.html
- Values 7474
- 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
..._ns duckdb_get_timestamp_ns ( duckdb_value val ); duckdb_interval duckdb_get_interval ( duckdb_value val ); duckdb_logical_type duckdb_get_value_type ( duckdb_value val ); duckdb_blob duckdb_get_blob ( duckdb_value val ); duckdb_bit duckdb_get_bit (...db_value val ); char * duckdb_get_varchar ( duckdb_value value ); duckdb_value duckdb_create_struct_value ( duckdb_logical_type type , duckdb_value * values ); duckdb_value duckdb_create_list_value ( duckdb_logical_type type , duckdb_value * values ,...idx_t value_count ); duckdb_value duckdb_create_array_value ( duckdb_logical_type type , duckdb_value * values , idx_t value_count ); duckdb_value duckdb_create_map_value ( duckdb_logical_type map_type ,... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Vectors 7453
- 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
...aces 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 th...en be obtained using duckdb_get_type_id . Vectors themselves 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, the underlying array can be obtained using the duckdb_vector_get_data method. The array can then be... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
DuckDB 2.0 Documentation / man.mtool.work