Results of 1 - 10 of about 16 for closed (0.007 sec.)
- Startup & Shutdown – DuckDB 13672
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ckdb_connection s have to explicitly be disconnected with duckdb_disconnect() and the duckdb_database has to be explicitly closed with duckdb_close() to avoid memory and file handle leaking. Example duckdb_database db ; duckdb_connection con ; if ( duc...eate_from_cache Creates a new database instance in the instance cache, or retrieves an existing database instance. Must be closed with 'duckdb_close'. Syntax duckdb_state duckdb_get_or_create_from_cache ( duckdb_instance_cache instance_cache , const ch...abase file stored at the given path. If no path is given a new in-memory database is created instead. The database must be closed with 'duckdb_close'. Syntax duckdb_state duckdb_open ( const char * path , duckdb_database * out_database ); Parameters pa... - https://man.mtool.work/duckdb/1.3/clients/c/connect.html
- Python DB API – DuckDB 11558
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...-safe but is locked for the duration of the queries, effectively serializing database access in this case. Connections are closed implicitly when they go out of scope or if they are explicitly closed using close() . Once the last connection to a databa...se instance is closed, the database instance is closed as well. Querying SQL queries can be sent to DuckDB using the execute() method of connect... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- R Client – DuckDB 9981
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...file (shared between processes) con <- dbConnect ( duckdb (), dbdir = "my-db.duckdb" , read_only = TRUE ) Connections are closed implicitly when they go out of scope or if they are explicitly closed using dbDisconnect() . To shut down the database ins...r registration. This prevents the data frame from being garbage-collected. The reference is cleared when the connection is closed, but can also be cleared manually using the duckdb_unregister() method. Also refer to the data import documentation for mo... - https://man.mtool.work/duckdb/1.3/clients/r.html
- Timestamp Issues – DuckDB 9184
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ics almost always uses half-open binning intervals to avoid overlaps at the ends. Unfortunately, the BETWEEN operator is a closed-closed interval: x BETWEEN begin AND end -- expands to begin <= x AND x <= end -- not begin <= x AND x < end To avoid this... - https://man.mtool.work/duckdb/1.3/guides/sql_features/timestamps.html
- Aggregate Functions – DuckDB 9184
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...lue pairs representing the provided upper boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A boundary at the largest value of the datatype is automatically added when elements larger t...lue pairs representing the provided upper boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A boundary at the largest value of the datatype is automatically added when elements larger t...n the specified order) value of x . Intuitively, assigns to each value of x an equisized sub-interval (left-open and right-closed except for the initial interval) of the interval [0, 1] , and picks the value of the sub-interval that contains pos . This... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Python API – DuckDB 8924
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...query the table con . table ( "test" ). show () # explicitly close the connection con . close () # Note: connections also closed implicitly when they go out of scope You can also use a context manager to ensure that the connection is closed: import du... - https://man.mtool.work/duckdb/1.3/clients/python/overview.html
- Timestamp Functions – DuckDB 8127
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...or TIMESTAMP types. Name Description generate_series(timestamp, timestamp, interval) Generate a table of timestamps in the closed range, stepping by the interval. range(timestamp, timestamp, interval) Generate a table of timestamps in the half open ran...s table function bounds. generate_series(timestamp, timestamp, interval) Description Generate a table of timestamps in the closed range, stepping by the interval. Example generate_series(TIMESTAMP '2001-04-10', TIMESTAMP '2001-04-11', INTERVAL 30 MINUT... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 8127
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...IME ZONE types. Name Description generate_series(timestamptz, timestamptz, interval) Generate a table of timestamps in the closed range (including both the starting timestamp and the ending timestamp), stepping by the interval. range(timestamptz, times...ble function bounds. generate_series(timestamptz, timestamptz, interval) Description Generate a table of timestamps in the closed range (including both the starting timestamp and the ending timestamp), stepping by the interval. Example generate_series(... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Spatial Functions – DuckDB 7867
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Returns true if the geometries intersect ST_Intersects_Extent Returns true if the extent of two geometries intersects ST_IsClosed Check if a geometry is 'closed' ST_IsEmpty Returns true if the geometry is "empty". ST_IsRing Returns true if the geometry...is a ring (both ST_IsClosed and ST_IsSimple). ST_IsSimple Returns true if the geometry is simple ST_IsValid Returns true if the geometry is valid ST_L...rsects_Extent ( geom1 GEOMETRY , geom2 GEOMETRY ) Description Returns true if the extent of two geometries intersects ST_IsClosed Signature BOOLEAN ST_IsClosed ( geom GEOMETRY ) Description Check if a geometry is 'closed' ST_IsEmpty Signatures BOOLEAN... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Complete API – DuckDB 7607
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...eate_from_cache Creates a new database instance in the instance cache, or retrieves an existing database instance. Must be closed with 'duckdb_close'. Syntax duckdb_state duckdb_get_or_create_from_cache ( duckdb_instance_cache instance_cache , const ch...abase file stored at the given path. If no path is given a new in-memory database is created instead. The database must be closed with 'duckdb_close'. Syntax duckdb_state duckdb_open ( const char * path , duckdb_database * out_database ); Parameters pa...n of duckdb_open. Creates a new database or opens an existing database file stored at the given path. The database must be closed with 'duckdb_close'. Syntax duckdb_state duckdb_open_ext ( const char * path , duckdb_database * out_database , duckdb_con... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
DuckDB 1.3 Documentation / man.mtool.work