Results of 1 - 10 of about 26 for started (0.002 sec.)
- Copying an In-Memory Database to a File 12266
- 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
... - https://man.mtool.work/duckdb/2.0/guides/snippets/copy_in-memory_database_to_fil...
- ODBC Extension 11819
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...ransaction is called on the connection, the auto-commit mode on this connection is disabled and an implicit transaction is started. There is currently no support for enabling auto-commit back on such connection. After the transaction is started, call od...bc_commit or odbc_rollback to complete this transaction. After the completion is performed, new implicit transaction is started on this connection automatically. Performance ODBC is not a high-performance API, odbc_query uses multiple API calls per-r... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Overview 10480
- Installation To use the DuckDB C API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C API is 2.0.0. DuckDB implements a custom C API modeled somewhat following the SQLite C API. The API is contain
...ed in the duckdb.h header. Continue to Startup & Shutdown to get started, or check out the Full API overview . C API v2 Warning The C API v2 is not yet stable. Its interface may change in upcomin... - https://man.mtool.work/duckdb/2.0/clients/c/overview.html
- PostgreSQL Extension Functions 9588
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...nal named parameters: use_transaction ( BOOLEAN , default: TRUE ): whether to start a PostgreSQL transaction if it was not started before. Returns A table with the following columns: Success ( BOOLEAN ): a flag whether the cache clearing was successful...nal named parameters: use_transaction ( BOOLEAN , default: TRUE ): whether to start a PostgreSQL transaction if it was not started before. params ( STRUCT ): query parameters that are passed to the PostgreSQL server; only supported when the text protoco... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Quack Remote Protocol 9588
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...uack: scheme, e.g., quack:hostname:port with the port defaulting to 9494 . Server-Side Usage Starting a Server A server is started from an existing DuckDB session. Everything that the session can see (in-memory tables, attached files, schemas) becomes r...orker"}' ); meta is merged with auto-computed duckdb_version and platform keys; user-supplied keys win on conflict. whoami_started_at (an ISO 8601 timestamp) overrides the uptime anchor, otherwise uptime is measured from extension load.... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- SET and RESET Statements 9588
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...the database file or persisted across DuckDB instances. If all connections to an instance are closed and a new instance is started, configuration options use their defaults unless they are set again. For example, in DuckDB 2.0 the TimeZone option defaul... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- VACUUM Statement 9588
- The VACUUM statement only has basic support in DuckDB and is mostly provided for PostgreSQL-compatibility. Some variants of it, such as when calling for a given column, recompute the distinct statistics (the number of distinct entities) if
...he indexes are rebuilt after vacuuming (the default, 0 , disables the fallback). It can only be set before the database is started or per database as an ATTACH option. Reclaiming Space The VACUUM statement does not reclaim space. For instructions on rec... - https://man.mtool.work/duckdb/2.0/sql/statements/vacuum.html
- Reference 9141
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...whoami_hostname VARCHAR (empty) Network hostname / public address. whoami_region VARCHAR (empty) Deployment region. whoami_started_at VARCHAR (empty) Node start time (ISO 8601 timestamp). Anchors uptime . whoami_meta VARCHAR {} Provider-specific metadat...a as JSON. quack_loaded_at_us BIGINT Epoch microseconds at extension load Fallback uptime anchor when whoami_started_at is empty. Logging Two log types are registered by the extension. Enable them to debug connectivity or measure request t... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Command Line Client 8695
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...es the most common uses of the CLI client. If you have tldr installed, you can display it by running tldr duckdb . Getting Started Once the CLI executable has been downloaded, decompress it and save it to any directory. Navigate to that directory in a t...ia the CONNECT statement , the first Ctrl + D disconnects and returns to the local database; press it again to exit. A CLI started with -connect exits on the first Ctrl + D . If you used a persistent database, DuckDB will automatically checkpoint (save... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Windows 8695
- On Windows, DuckDB requires the Microsoft Visual C++ Redistributable package both as a build-time and runtime dependency. Note that unlike the build process on UNIX-like systems, the Windows builds directly call CMake. Clang-cl To build Duc
...Open a shell where the Visual Studio environment variables are set (e.g., the “x64 Native Tools Command Prompt” or a shell started from it). Run the following commands in a Bash shell from the root of the DuckDB repository: bash export GEN=ninja export... - https://man.mtool.work/duckdb/2.0/dev/building/windows.html
DuckDB 2.0 Documentation / man.mtool.work