Results of 1 - 10 of about 11 for sync (0.002 sec.)
- Python 13194
- The DuckDB Python package has its own repository at duckdb/duckdb-python and uses nanobind 3 to create Python bindings with DuckDB. Prerequisites This guide assumes: You have a full clone of the DuckDB Python package source, including its g
...nd Build Set up the development environment in two steps: # Install the build dependencies without building the project uv sync --only-group build --no-install-project -p 3.13 # Build and install the project without build isolation uv sync --no-build...ebug build in build/debug/ . Editable builds use the full CPython API; only wheels use the stable ABI. Why two steps? * uv sync performs editable installs by default with scikit-build-core using a persistent build-dir * The build happens in an isolat...les the extension with --coverage into build/coverage/ for C++ coverage), then run the tests under coverage: COVERAGE=1 uv sync --no-build-isolation -v --reinstall -p 3.13 COVERAGE=1 uv run --no-build-isolation coverage run -m pytest ./tests --verbos... - https://man.mtool.work/duckdb/2.0/dev/building/python.html
- Swift Client 10455
- DuckDB has a Swift client. See the announcement post for details. Instantiating DuckDB DuckDB supports both in-memory and persistent databases. To work with an in-memory database, run: let database = try Database(store: .inMemory) To work w
...} } Loading a CSV File We load the data from NASA's Exoplanet Archive : wget https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+pl_name+,+disc_year+from+pscomppars&format=csv -O downloaded_exoplanets.csv Once we have our CSV downloaded l...to DuckDB: CREATE TABLE exoplanets AS SELECT * FROM read_csv('downloaded_exoplanets.csv'); Let's package this up as a new asynchronous factory method on our ExoplanetStore type: import DuckDB import Foundation final class ExoplanetStore { // Factory...method to create and prepare a new ExoplanetStore static func create() async throws -> ExoplanetStore { // Create our database and connection as described above let database = try Database(store: .in... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- Beekeeper Studio SQL Editor 9851
- Beekeeper Studio is a free, open-source SQL editor and database manager with a modern, easy-to-use interface. It is available for Windows, macOS, and Linux, and also offers a paid Ultimate tier with cloud sync and team-sharing features. Bee
... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/beekeeper_studio.html
- I/O 9548
- Warning DuckDB ships with safe defaults. The configuration options described on this page are advanced options, so proceed with caution when changing them. Asynchronous I/O New Asynchronous I/O was introduced in DuckDB 2.0. Starting with v2
....0, DuckDB supports asynchronous I/O. Instead of blocking a worker thread until requested data arrives, DuckDB issues reads in the background and ke...equests in flight while worker threads process data that has already arrived. This can significantly speed up queries when synchronous I/O does not saturate the available bandwidth, e.g., when reading data from object storage such as S3. For a detail...ed explanation of the design and benchmark results, see the “Asynchronous I/O in DuckDB” blog post . Supported Formats Asynchronous I/O is currently supported for the following formats: Par... - https://man.mtool.work/duckdb/2.0/data/io.html
- INSERT Statements 9246
- 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
...o load data in a loop, avoid executing 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 separa...te transaction, meaning fsync will be called for every statement. This is typically unnecessary when bulk loading and will significantly slow down your... - https://man.mtool.work/duckdb/2.0/data/insert.html
- Profile and Monitor 8641
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...nother thread. Call interrupt_handle() on the connection to get an Arc<InterruptHandle> . InterruptHandle is both Send and Sync , so you can move it, or the connection, to another thread and call interrupt() from wherever is convenient. The interrupt... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- Connect 7717
- Overview Every DuckDB feature reachable from Rust starts with a Connection . Opening in-memory and file-backed databases, configuring a database instance with Config , opening read-only, pooling connections across threads, the crate's threa
...essMode has three variants: Automatic (the default), ReadOnly , and ReadWrite . Thread Safety A Connection is Send but not Sync : it can be moved to another thread, but it cannot be shared between threads at the same time. The recommended pattern is... - https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
- Import Data 7717
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...rows, but errors raised during that implicit flush are discarded, because Rust's Drop cannot report them. The Appender is Sync but not Send , because it borrows the Connection . To append from another thread, move the Connection to that thread and c... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- Write User Defined Functions 7415
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...ore::{DataChunkHandle, LogicalTypeHandle, LogicalTypeId}, vtab::{BindInfo, InitInfo, TableFunctionInfo, VTab}, }; use std::sync::atomic::{AtomicUsize, Ordering}; struct Numbers; // Computed once from the call's arguments; read-only during execution.... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Versioning of Extensions 7112
- 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
...Extensions In general for extensions the release cycle depends on their stability level. unstable extensions are often in sync with DuckDB's release cycle, but may also be quietly updated between DuckDB releases. pre-release and stable extensions fo... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
DuckDB 2.0 Documentation / man.mtool.work