Results of 1 - 10 of about 33 for Ensure (0.002 sec.)
- Versioning of Extensions 11615
- Extension Versioning Most software has some sort of version number. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of t
...stable, whereas v13.11.0 probably is stable) Just like DuckDB itself , DuckDB extensions have their own version number. To ensure consistent semantics of these version numbers across the various extensions, DuckDB's Core Extensions use a versioning sch...work for version 1.0.0. In most cases, this will not cause any issues and is fully transparent; DuckDB will automatically ensure it installs the correct binary for its version. For extension developers, this means that they must ensure that new binari... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
- Copying an In-Memory Database to a File 11615
- Imagine the following situation – you started DuckDB in in-memory mode but would like to persist the state of your database to disk. To achieve this, attach to a new disk-based database and use the COPY FROM DATABASE ... TO command : ATTACH
...'my_database.db'; COPY FROM DATABASE memory TO my_database; DETACH my_database; Ensure that the disk-based database file does not exist before attaching to it.... - https://man.mtool.work/duckdb/2.0/guides/snippets/copy_in-memory_database_to_fil...
- Vectors 11182
- 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
...ctor_get_data ( duckdb_vector vector ); uint64_t * duckdb_vector_get_validity ( duckdb_vector vector ); void duckdb_vector_ensure_validity_writable ( duckdb_vector vector ); void duckdb_vector_assign_string_element ( duckdb_vector vector , idx_t index...r to get the data from Return Value The pointer to the validity mask, or NULL if no validity mask is present duckdb_vector_ensure_validity_writable Ensures the validity mask is writable by allocating it. After this function is called, duckdb_vector_get...LL values to be written to the vector, regardless of whether a validity mask was present before. Syntax void duckdb_vector_ensure_validity_writable ( duckdb_vector vector ); Parameters vector : The vector to alter duckdb_vector_assign_string_element As... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Multiple Python Threads 11182
- This page demonstrates how to simultaneously insert into and read from a DuckDB database across multiple Python threads. This could be useful in scenarios where new data is flowing in and an analysis should be periodically re-run. Note that
...'read_thread_' + str(j))) # Shuffle the threads to simulate a mix of readers and writers random.seed(6) # Set the seed to ensure consistent results when testing random.shuffle(threads) Run Threads and Show Results Now, kick off all threads to run in p...erspersed as expected due to the randomization. # Kick off all threads in parallel for thread in threads: thread.start() # Ensure all threads complete before printing final results for thread in threads: thread.join() print(duckdb_con.execute(""" SELEC... - https://man.mtool.work/duckdb/2.0/guides/python/multiple_threads.html
- Release Cycle 10315
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
...nsists of 3 main phases: Mid-cycle , Pre-release and Feature freeze . These phases are clearly defined and communicated to ensure the whole team is synchronized and working together towards the next release. Phase 1: Mid-Cycle Active DuckDB Branches ma...eatures are no longer allowed to be merged into vx.<y+1>-codename and only bug fixes are merged. This phase is intended to ensure the quality of the upcoming release. During this phase additional testing and benchmarking is performed while reducing the...s automatically ( vx.y-codename becomes inactive by definition) Single branch extensions require manual version updates to ensure changes are included in the targeted release. ↩ ↩ Patch releases during pre-release or feature-freeze phases are uncommon.... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- Extensions 9882
- DuckDB has a flexible extension mechanism that allows for dynamically loading extensions. Extensions can enhance DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionali
.... For example, to install and load the spatial extension , run: INSTALL AND LOAD spatial; With this statement, DuckDB will ensure the spatial extension is installed (skipping the installation if it is already installed), then proceed to load the spatia...B release due to their nature of being built into the DuckDB binary, installable extensions can and do receive updates. To ensure all currently installed extensions are on the most recent version, call: UPDATE EXTENSIONS; For more details on extension... - https://man.mtool.work/duckdb/2.0/extensions/overview.html
- INSERT Statements 9449
- INSERT statements are the standard way of loading data into a relational database. When using INSERT statements, the values are supplied row-by-row. While simple, there is significant overhead involved in parsing and processing individual I
...uting the statements in auto-commit mode. After every commit, the database is required to sync the changes made to disk to ensure no data is lost. In auto-commit mode every single statement will be wrapped in a separate transaction, meaning fsync will... - https://man.mtool.work/duckdb/2.0/data/insert.html
- S3 Express One 8583
- In late 2023, AWS announced the S3 Express One Zone , a high-speed variant of traditional S3 buckets. DuckDB can read S3 Express One buckets using the httpfs extension . Credentials and Configuration The configuration of S3 Express One buck
...REGION '⟨us-east-1⟩', ENDPOINT 's3express-⟨use1-az5⟩.⟨us-east-1⟩.amazonaws.com' ); Instance Location For best performance, ensure the EC2 instance is in the same availability zone as the S3 Express One bucket you are querying. To determine the mapping... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
- Storage Versions and Format 8583
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compati
...read and operate on files created by the previous DuckDB version – DuckDB 0.9. For future DuckDB versions, our goal is to ensure that any DuckDB version released after can read files created by previous versions, starting from this release. We want to...ensure that the file format is fully backward compatible. This allows you to keep data stored in DuckDB files around and guarante... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- COPY Statement 8583
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...prepared statement into the lineitem table: PREPARE v1 AS COPY lineitem FROM ($1); EXECUTE v1('lineitem.json'); Syntax To ensure compatibility with PostgreSQL, DuckDB accepts COPY ... FROM statements that do not fully comply with the railroad diagram...false APPEND When true , in the event a filename pattern is generated that already exists, the path will be regenerated to ensure no existing files are overwritten. Only has an effect when used with options that write multiple files, such as PARTITION_...hether or not to write partition columns into files. Only has an effect when used with PARTITION_BY . BOOL false Syntax To ensure compatibility with PostgreSQL, DuckDB accepts COPY ... TO statements that do not fully comply with the railroad diagram sh... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
DuckDB 2.0 Documentation / man.mtool.work