Results of 1 - 10 of about 59 for creates (0.006 sec.)
- Values 16223
- 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
...Syntax void duckdb_destroy_value ( duckdb_value * 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 char * text ); Parameters text : T...-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_varchar_length ( const char * text , idx_t length ); Parameters te...gth : The length of the text Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_bool Creates a value from a boolean Syntax duckdb_value duckdb_create_bool ( bool input ); Parameters input : The boolean value Return... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Complete API 12371
- 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
...n_fold ( duckdb_client_context context , duckdb_expression expr , duckdb_value * out_value ); duckdb_create_instance_cache Creates a new database instance cache. The instance cache is necessary if a client/program (re)opens multiple databases to the sam...he database instance cache. Syntax duckdb_instance_cache duckdb_create_instance_cache ( ); duckdb_get_or_create_from_cache Creates a new database instance in the instance cache, or retrieves an existing database instance. Must be closed with 'duckdb_clo...e_cache ( duckdb_instance_cache * instance_cache ); Parameters instance_cache : The instance cache to destroy. duckdb_open Creates a new database or opens an existing database file stored at the given path. If no path is given a new in-memory database i... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Files Created by DuckDB 8914
- DuckDB creates several files and directories on disk. This page lists both the global and the local ones. Global Files and Directories DuckDB creates the following global files and directories in the user's home directory (denoted with ~ ):
...file per repository. Created by CREATE EXTENSION REPOSITORY . Yes (v2.0 and later) Yes Local Files and Directories DuckDB creates the following files and directories in the working directory (for in-memory connections) or relative to the database file... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/files_cr...
- Spatial Functions 8505
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...urns the "boundary" of a geometry ST_Buffer Returns a buffer around the input geometry at the target distance ST_BuildArea Creates a polygonal geometry by attempting to "fill in" the input geometry. ST_Centroid Returns the centroid of a geometry ST_Coll...rectangular polygon from min/max coordinates ST_MakeLine Create a LINESTRING from a list of POINT geometries ST_MakePoint Creates a GEOMETRY point from an pair of floating point numbers. ST_MakePolygon Create a POLYGON from a LINESTRING shell ST_MakeVa...Perimeter_Spheroid Returns the length of the perimeter in meters using an ellipsoidal model of the earths surface ST_Point Creates a GEOMETRY point ST_Point2D Creates a POINT_2D ST_Point2DFromWKB Deserialize a POINT_2D from a WKB encoded blob ST_Point3D... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Types 8345
- 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
...b_decimal val ); Parameters val : The decimal value. Return Value The converted double element. 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...ical_type type , const char * alias ); Parameters type : The logical type alias : The alias to set duckdb_create_list_type Creates a LIST type from its child type. The return type must be destroyed with duckdb_destroy_logical_type . Syntax duckdb_logica..._logical_type type ); Parameters type : The child type of the list Return Value The logical type. duckdb_create_array_type Creates an ARRAY type from its child type. The return type must be destroyed with duckdb_destroy_logical_type . Syntax duckdb_logi... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Startup & Shutdown 8024
- 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
...uckdb_get_table_names ( duckdb_connection connection , const char * query , bool qualified ); duckdb_create_instance_cache Creates a new database instance cache. The instance cache is necessary if a client/program (re)opens multiple databases to the sam...he database instance cache. Syntax duckdb_instance_cache duckdb_create_instance_cache ( ); duckdb_get_or_create_from_cache Creates a new database instance in the instance cache, or retrieves an existing database instance. Must be closed with 'duckdb_clo...e_cache ( duckdb_instance_cache * instance_cache ); Parameters instance_cache : The instance cache to destroy. duckdb_open Creates a new database or opens an existing database file stored at the given path. If no path is given a new in-memory database i... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- List Functions 7863
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...) Alias for list_filter . flatten(nested_list) Flattens a nested list by one level. generate_series(start[, stop][, step]) Creates a list of values between start and stop - the stop parameter is inclusive. grade_up(list[, col1][, col2]) Alias for list_g...mbda function. See list_transform examples . list_unique(list) Counts the unique elements of a list . list_value(arg, ...) Creates a LIST containing the argument values. list_var_pop(list) Applies aggregate function var_pop to the list . list_var_samp(l...replaced with NULL . If truncate is set, all lists are truncated to the smallest list length. range(start[, stop][, step]) Creates a list of values between start and stop - the stop parameter is exclusive. reduce(list, lambda(x,y)[, initial_value]) Alia... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- PHP Client 7776
- 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
..., false, 1.1), (3, null, 1.2);'); $duckDB->query('SELECT * FROM test')->print(); As you probably guessed, DuckDB::create() creates a new connection to the specified database, or creates a new one if it doesn't exist yet and then establishes the connecti...requests. Notice the difference between the static method sql and the non-static method query . While the first one always creates and destroys a new in-memory database, the second one uses a previously established connection and should be the preferred... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php.html
- Geometry Functions 7776
- This section describes the functions for examining and manipulating GEOMETRY values. The spatial extension provides additional functions for working with GEOMETRY values, which are documented in the Spatial Functions section. Geometry Opera
...INT(5 5)'::GEOMETRY && 'LINESTRING(0 0, 10 20)'::GEOMETRY true Built-in Geometry Functions Name Description ST_GeomFromWKB Creates a geometry from Well-Known Binary (WKB) representation ST_AsWKB Returns the Well-Known Binary (WKB) representation of the...ry ST_SetCRS Sets the Coordinate Reference System (CRS) identifier of the geometry ST_GeomFromWKB function | Description | Creates a geometry from Well-Known Binary (WKB) representation | | Example | ST_GeomFromWKB('\x01\x01\x00\x00\x00\x00\x00\x00\x00\... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- CREATE SECRET Statement 7776
- The CREATE SECRET statement creates a new secret in the Secrets Manager . Syntax for CREATE SECRET Warning When using the command line client , the CREATE SECRET statements are stored in your DuckDB history as plain text. Syntax for DROP SE
... - https://man.mtool.work/duckdb/2.0/sql/statements/create_secret.html
DuckDB 2.0 Documentation / man.mtool.work