Results of 1 - 10 of about 69 for Main (0.002 sec.)
- Release Cycle 15639
- 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>.<
...vx.y.<n> releases vx.<y+1>-codename : The branch name that is used for the branch that will produce the next minor release Main release cycle : The branches, commits, and PRs related to producing vx.<y+1>.0 and vx.y.<z+1> releases Active branch : A b...ranch that is part of the main release cycle. Either main or vx. -codename where n >= 0 Single branch extension : Extension with 1 active branch. Since m...ain is always an active branch this is always main. This means all other branches of format vx.y-codename must be vx.<y-n>-codename where n >= 1 Multi branch extension : Ext... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- USE Statement 11665
- The USE statement selects a database and optional schema, or just a schema to use as the default. Examples --- Sets the 'memory' database as the default. Will use 'main' schema implicitly or error --- if it does not exist. USE memory; --- S
...ets the 'duck.main' database and schema as the default USE duck.main; -- Sets the `main` schema of the currently selected database as the def...ault, in this case 'duck.main' USE main; Syntax The USE statement sets a default database, schema or database/schema combination to use for future opera... - https://man.mtool.work/duckdb/2.0/sql/statements/use.html
- Information Schema 11071
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...ng the table (always the current database). VARCHAR 'my_db' table_schema Name of the schema containing the table. VARCHAR 'main' table_name Name of the table. VARCHAR 'widgets' column_name Name of the column. VARCHAR 'price' ordinal_position Ordinal...the (declared or implicit) fractional seconds precision of the type for this column, that is, the number of decimal digits maintained following the decimal point in the seconds value. No fractional seconds are currently supported in DuckDB. For all o...table_schema Name of the schema that contains the table that contains the column that is used by some constraint VARCHAR 'main' table_name Name of the table that contains the column that is used by some constraint VARCHAR 'widgets' column_name Name... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Deploy 8894
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...and mirrored, and the security considerations involved. A DuckDB-Wasm deployment needs to access the following components: Main Library Component. Distributed as TypeScript and compiled to JavaScript code. For further details, see below. JS Worker Co...rther details, see below. DuckDB Extensions. Any relevant extensions the deployment loads. For further details, see below. Main Library Component This component is distributed as TypeScript or CommonJS JavaScript in the npm @duckdb/duckdb-wasm packag...e. You can deploy it in one of three ways: Bundled together with your application Served from a same-origin (sub-)domain and included at runtime Served from a third-party CDN such as jsDelivr It cannot be served as-is: it requires transpilatio... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- List Tables 8413
- The SHOW TABLES command can be used to obtain a list of all tables within the selected schema. CREATE TABLE tbl (i INTEGER); SHOW TABLES; name tbl SHOW or SHOW ALL TABLES can be used to obtain a list of all tables within all attached databa
...HEMA s1; CREATE TABLE s1.tbl (v VARCHAR); SHOW ALL TABLES; database schema name column_names column_types temporary memory main tbl [i] [INTEGER] false memory s1 tbl [v] [VARCHAR] false SHOW TABLES FROM db can be used to list all tables in a given da...tabase or schema. ATTACH 'db.duckdb'; CREATE TABLE db.main_tbl (u VARCHAR); CREATE SCHEMA db.s1; CREATE TABLE db.s1.schema_tbl (v VARCHAR); SHOW TABLES FROM db; name main_tbl schema... - https://man.mtool.work/duckdb/2.0/guides/meta/list_tables.html
- Full-Text Search Extension 8356
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...r the specified table. Name Type Description input_table VARCHAR Qualified name of specified table, e.g., 'table_name' or 'main.table_name' input_id VARCHAR Column name of document identifier, e.g., 'document_identifier' input_values... VARCHAR Colum...lts to 1 overwrite BOOLEAN Whether to overwrite an existing index on a table. Defaults to 0 incremental BOOLEAN Whether to maintain the FTS index with triggers after inserts and deletes on the input table. Requires the document identifier column to b...s the index under a newly created schema. The schema will be named after the input table: if an index is created on table 'main.table_name' , then the schema will be named 'fts_main_table_name' . PRAGMA drop_fts_index drop_fts_index(input_table) Drop... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Analyzing a Git Repository 8173
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...--pretty=format:%ad?%h?%an?%s > git-log.csv The resulting file looks like this: 2025-02-25T18:12:54+01:00?d608a31e13?Mark?MAIN_BRANCH_VERSIONING: Adopt also for Python build and amalgamation (#16400) 2025-02-25T15:05:56+01:00?920b39ad96?Mark?Read su...pport for Parquet Float16 (#16395) 2025-02-25T13:43:52+01:00?61f55734b9?Carlo Piovesan?MAIN_BRANCH_VERSIONING: Adopt also for Python build and amalgamation 2025-02-25T12:35:28+01:00?87eff7ebd3?Mark?Fix issue #16377...──────────────────────────────────────────────────────────────────────────┤ │ 2025-02-25 18:12:54+01 │ d608a31e13 │ Mark │ MAIN_BRANCH_VERSIONING: Adopt also for Python build and amalgamation (#16400) │ │ 2025-02-25 15:05:56+01 │ 920b39ad96 │ Mark │... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- ATTACH and DETACH Statements 7932
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...sion by default (equivalent to STORAGE_VERSION 'latest' ), so they cannot be read by older DuckDB versions. Therefore, the main use of this option is to create database files that remain readable by older DuckDB versions: ATTACH 'file.db' (STORAGE_VE...By default, it uses AES encryption with a key length of 256 bits using the recommended GCM mode. The encryption covers the main database file, the write-ahead-log (WAL) file, and even temporary files. To attach to an encrypted database, use the ATTAC...the close() function in Python , does not release the locks held on the database files as the file handles are held by the main DuckDB instance (in Python's case, the duckdb module). DETACH Syntax Name Qualification The fully qualified name of catalo... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- EXPLAIN: Inspect Query Plans 7876
- EXPLAIN SELECT * FROM tbl; The EXPLAIN statement displays the physical plan, i.e., the query plan that will get executed, and is enabled by prepending the query with EXPLAIN . The physical plan is a tree of operators that are executed in a
...───────────╯ ├──────────────────────────────╮ ╭─ Seq Scan ──┴────────────╮ ╭─ Seq Scan ───┴──────────────╮ │ Table: memory.main.exams │ │ Table: memory.main.students │ │ Type: Sequential Scan │ │ Type: Sequential Scan │ │ Projections: sid │ │ Project...for each operator. Table scan operators display the fully qualified table name including catalog and schema (e.g., memory.main.exams ). Additional Explain Settings The EXPLAIN statement supports additional settings that can be used to control the ou... - https://man.mtool.work/duckdb/2.0/guides/meta/explain.html
- Troubleshoot 7763
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...library on the loader path: # On Linux. CGO_ENABLED=1 CGO_LDFLAGS="-lduckdb -L/path/to/libs" go build -tags=duckdb_use_lib main.go LD_LIBRARY_PATH=/path/to/libs ./main # On macOS. CGO_ENABLED=1 CGO_LDFLAGS="-lduckdb -L/path/to/libs" go build -tags=du...ckdb_use_lib main.go DYLD_LIBRARY_PATH=/path/to/libs ./main TIMESTAMP versus TIMESTAMP_TZ In the C API, DuckDB stores both TIMESTAMP and TIM... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
DuckDB 2.0 Documentation / man.mtool.work