Results of 1 - 6 of about 6 for term (0.004 sec.)
- Glossary of Terms 12722
- This page contains a glossary of a few common terms used in DuckDB. Terms In-Process Database Management System The DBMS runs in the client application's process instead of running as a separate process, which is common in the traditional c
...lient–server setup. An alternative term is embeddable database management system. In general, the term “embedded database management system” should be avoided, as... - https://man.mtool.work/duckdb/2.0/guides/glossary.html
- Release Cycle 10181
- 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>.<
...and v2.0.0 in October 2026 Patch releases are issued as needed for all supported versions: The latest stable version Long Term Support (LTS) versions within their support period Versions with extended support (e.g., v1.5, which is supported until Ma...rch 2027) All releases and their end-of-life dates are listed in the Release Calendar Terminology In the release docs we use some basic terminology to describe versions and branches. We briefly go over them here....ee branch extension : Extension with three active branches: main, vx.y-codename , and vx.<y+1>-codename LTS release : Long term support release. These releases will receive support (patch releases) beyond their lifetime in the active release cycle. C... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- WITH Clause 8554
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...allows the definition of CTEs which can refer to themselves. Note that the query must be formulated in a way that ensures termination, otherwise, it may run into an infinite loop. Example: Fibonacci Sequence WITH RECURSIVE can be used to make recurs...h), path; startNode endNode path 1 8 [1, 3, 8] 1 8 [1, 5, 8] Accessing the Union Table with recurring Within the recursive term of a WITH RECURSIVE CTE, the CTE name (e.g., counter ) refers to the rows produced by the last iteration . To access all r...us iterations, while counter in the FROM clause only contains the rows from the most recent iteration. This is useful when termination conditions or calculations depend on the full accumulated result rather than just the previous iteration. Recursive... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- Merge Statement for SCD Type 2 8079
- This is a practical, step-by-step guide to using DuckDB's MERGE statement (introduced in v1.4.0) to perform upserts and build Slowly Changing Dimension Type 2 (SCD Type 2) tables . Type 2 SCDs let you keep full historical versions of record
...deletes. Works directly on Parquet, CSV, databases, thanks to DuckDB's connectivity! Prerequisites Basic SQL knowledge Key Terminology Term Meaning Target table The main/master table you are updating (e.g., master_ducks ) Source table The incoming/ne... - https://man.mtool.work/duckdb/2.0/guides/sql_features/merge.html
- SQL Introduction 7860
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...system (RDBMS). That means it is a system for managing data stored in relations. A relation is essentially a mathematical term for a table. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and ea...m temperature on a day prcp FLOAT, date DATE ); You can enter this into the shell with the line breaks. The command is not terminated until the semicolon. White space (i.e., spaces, tabs and newlines) can be used freely in SQL commands. That means yo...the WHERE clause: Binder Error: WHERE clause cannot contain aggregates! This restriction exists because the WHERE clause determines which rows will be included in the aggregate calculation; so obviously it has to be evaluated before aggregate functio... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
- Complete API 7384
- 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
...recated in v1.0 is to denote that they are not part of the v1.0 stable API, which contains methods that are available long-term. API Reference Overview Open Connect duckdb_instance_cache duckdb_create_instance_cache (); duckdb_state duckdb_get_or_cre...does not work correctly if the string contains null bytes. Return Value The text value at the specified location as a null-terminated string, or nullptr if the value cannot be converted. The result must be freed with duckdb_free . Syntax char * duckd...( duckdb_prepared_statement prepared_statement , idx_t param_idx , duckdb_interval val ); duckdb_bind_varchar Binds a null-terminated varchar value to the prepared statement at the specified index. Syntax duckdb_state duckdb_bind_varchar ( duckdb_pre... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work