Results of 1 - 10 of about 11 for terminal (0.002 sec.)
- Command Line Client 12891
- 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.
...d Once the CLI executable has been downloaded, decompress it and save it to any directory. Navigate to that directory in a terminal and enter the command duckdb to run the executable. If in a PowerShell or POSIX shell environment, use the command ./duckd...SQL statement followed by a semicolon, then hit enter and it will be executed. Results will be displayed in a table in the terminal. If a semicolon is omitted, hitting enter will allow for multi-line SQL statements to be entered. SELECT 'quack' AS my_col...env('MY_DB_PATH')" Output Formats The .mode dot command may be used to change the appearance of the tables returned in the terminal output. These include the default duckbox mode, csv and json mode for ingestion by other tools, markdown and latex for doc... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Output Formats 11309
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...here by redirecting the terminal output to a file . Using the insert mode will build a series of SQL statements that can be used to insert the data at a la...l for building documentation and the latex mode is useful for writing academic papers. Warning Unicode handling in Windows Terminal When long results are displayed in Windows Terminal the more system utility is used by default to provide the scrolling th...10|20 Paging The CLI supports paging for large result sets using the .pager command. When enabled, results that exceed the terminal size are displayed in a pager (such as less ) for easier navigation. The pager has three modes: automatic (default) – The... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Dot Commands 10437
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...ender database content as SQL. TABLE is a LIKE pattern for the tables to dump .display_colors ⟨bold/underline⟩ Display all terminal colors and their names. See the 8-bit colors section .echo ⟨on/off⟩ Turn command echo on or off .edit Open an external tex...ult: 40 , -1 = all). For duckbox mode and agent mode .maxwidth ⟨COUNT⟩ Sets the maximum width in characters. 0 defaults to terminal width. Only for duckbox mode .mode ⟨MODE⟩ ⟨TABLE⟩ Set output mode .multiline Set multi-line mode (default) .nullvalue ⟨STR...for duckbox mode and for markdown mode in -agent mode. .maxwidth COUNT Sets the maximum width in characters. 0 defaults to terminal width. Only for duckbox mode. .mode MODE ?TABLE? Set output mode MODE is one of: ascii Columns/rows delimited by 0x1F and... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Agent Mode 8855
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...all of the following hold: A known AI agent environment variable (such as AI_AGENT ) is set. The standard output is not a terminal (for example, it is piped to another process). No output mode flag (such as -csv or -json ) was passed. You can also contr... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- marimo Notebooks 8481
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...tation as a Python file makes it simple to run notebooks as scripts. Installation To get started, install marimo from your terminal. Its sql extra also installs DuckDB, Polars and PyArrow: pip install "marimo[sql]" # or uv add "marimo[sql]" Run a tutoria...l: marimo tutorial sql SQL in marimo Create a notebook from your terminal with marimo edit notebook.py . Create SQL cells in one of three ways: Right-click the + button and pick SQL cell Convert a... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Result Verification 8232
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...LL SELECT 10, 20; ---- 42 84 10 20 The expected output hashes for every query in the test file will then be printed to the terminal, as follows: ================================================================================ SQL Query SELECT 42, 84 UNIO...====================== In a similar manner, mode output_result can be used to force the program to print the result to the terminal for every query run in the test file. Result Sorting Queries can have an optional field that indicates that the result sho... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Friendly CLI 7859
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- macOS 7503
- Prerequisites Install Xcode and Homebrew . Then, install the required packages with: brew install git cmake ninja Building DuckDB Clone and build DuckDB as follows. git clone https://github.com/duckdb/duckdb cd duckdb GEN=ninja make Once th
...ution: To prevent this, set the MallocNanoZone flag to 0: MallocNanoZone=0 make debug To apply this change for your future terminal sessions, you can add the following to your ~/.zshrc file: export MallocNanoZone=0... - https://man.mtool.work/duckdb/2.0/dev/building/macos.html
- CLI Charting with YouPlot 7503
- DuckDB can be used with CLI graphing tools to quickly pipe input to stdout to graph your data in one line. YouPlot is a Ruby-based CLI tool for drawing visually pleasing plots on the terminal. It can accept input from other programs by pipi
... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Tableau – A Data Visualization Tool 7379
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...the Taco file to the /Users/[User]/Documents/My Tableau Repository/Connectors folder. Then launch Tableau Desktop from the Terminal with the command line argument to disable signature validation: /Applications/Tableau\ Desktop\ ⟨year⟩.⟨quarter⟩.app/Conte... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
DuckDB 2.0 Documentation / man.mtool.work