Results of 1 - 10 of about 31 for shell (0.001 sec.)
- Autocomplete 12068
- The shell offers context-aware autocomplete of SQL queries through the autocomplete extension . autocomplete is triggered by pressing Tab . Multiple autocomplete suggestions can be present. You can cycle forwards through the suggestions by
...repeatedly pressing Tab , or Shift+Tab to cycle backwards. autocompletion can be reverted by pressing ESC twice. The shell autocompletes four different groups: Keywords Table names and table functions Column names and scalar functions File names...The shell looks at the position in the SQL statement to determine which of these autocompletions to trigger. For example: SELECT s s... - https://man.mtool.work/duckdb/2.0/clients/cli/autocomplete.html
- Dot Commands 11809
- 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
...text for PATTERN . Use .help shortcuts to display keyboard shortcuts .highlight ⟨on/off⟩ Toggle syntax highlighting in the shell on / off . See the query syntax highlighting section for more details .highlight_colors ⟨COMPONENT⟩ ⟨COLOR⟩ Configure the...e library used for processing interactive input .render_completion ⟨on/off⟩ Toggle displaying of completion prompts in the shell on / off .render_errors ⟨on/off⟩ Toggle rendering of errors (such as mismatched brackets and unclosed quotes) in the shell...⟨COL⟩ ⟨ROW⟩ Change the column and row separators .serve_command ⟨COMMAND⟩ Set the command executed by the -serve argument .shell ⟨CMD⟩ ⟨ARGS...⟩ Run CMD with ARGS... in a system shell .show Show the current values for various settings .singleline Set... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Windows 11016
- 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
...pment with C++” workload and the “C++ Clang Compiler for Windows” component. You also need Python, CMake, Ninja and a Bash shell with GNU Make (e.g., Git Bash with make installed). 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... - https://man.mtool.work/duckdb/2.0/dev/building/windows.html
- DuckDB Wasm Client 10887
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...er's machine. It offers a layered API to fit different needs: embedded as a JavaScript + WebAssembly library used as a Web shell built from source This page covers installation and basic usage; the other pages in this section cover instantiating the c...lient, importing data, running queries, loading extensions, and deploying it. Try It Yourself The shell below is a full DuckDB engine running in your browser — type a SQL query and run it right here: Note The shell above is it...self built with DuckDB-Wasm. It is the @duckdb/duckdb-wasm-shell package, one of the layered APIs listed above, running on top of the same DuckDB-Wasm library this page describes. Every q... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
- Logging 10499
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...ging(storage = 'memory'); -- Run some queries... SELECT * FROM duckdb_logs; In the CLI client , the default log storage is shell_log_storage , which prints log messages to the console but does not support querying. Therefore, the example above passes...nings. Setting level = 'warning' excludes lower-severity INFO messages. Note Switching the CLI to a log storage other than shell_log_storage means that warnings are no longer printed to the console. To restore the default behavior, run CALL enable_log...ging(storage = 'shell_log_storage') . Log Types In DuckDB, log messages can have an associated log type. Log types allow two main things: Fine-g... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Embedding DuckDB 10240
- CLI Client The Command Line Interface (CLI) client is intended for interactive use cases and not for embedding. As a result, it has more features that could be abused by a malicious actor. For example, the CLI client has the .sh feature tha
...t allows executing arbitrary shell commands. This feature is only present in the CLI client and not in any other DuckDB clients. .sh ls Tip Calling DuckDB's...CLI client via shell commands is not recommended for embedding DuckDB. It is recommended to use one of the client libraries, e.g., Python , R ,... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/embedding_du...
- Syntax Highlighting 9059
- Syntax highlighting in the CLI is available for macOS, Linux and Windows. SQL queries that are written in the shell are automatically highlighted using syntax highlighting. There are several components of a query that are highlighted in dif
...y time, you can place these commands in the ~/.duckdbrc file that is loaded on start-up of the CLI. Error Highlighting The shell has support for highlighting certain errors. In particular, mismatched brackets and unclosed quotes are highlighted in red... - https://man.mtool.work/duckdb/2.0/clients/cli/syntax_highlighting.html
- Install Script 8541
- You can install the DuckDB CLI client using an install script. Linux and macOS To use the DuckDB install script on Linux and macOS, run: curl https://install.duckdb.org | bash Click to see the output of the install script. % Total % Receive
...s/your_user/.duckdb/cli/latest/duckdb to /Users/your_user/.duckdb/cli/2.0.0/duckdb Hint: Append the following line to your shell profile: export PATH="/Users/your_user/.duckdb/cli/latest":$PATH To launch DuckDB 2.0.0 now, type /Users/your_user/.duckdb...ersion of DuckDB to ~/.duckdb/cli/latest/duckdb . To add the DuckDB binary to your path, append the following line to your shell profile or RC file (e.g., ~/.bashrc , ~/.zshrc ): export PATH="~/.duckdb/cli/latest":$PATH You can install past DuckDB rel...provide a beta install script. To use it, run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install.duckdb.org/install.ps1 | iex"... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/install_sc...
- Editing 8412
- The linenoise-based CLI editor is available for macOS, Linux and Windows. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts that are based on Emacs mode of readline . Below is a list of available commands. Yo
...rt a newline after the cursor Ctrl + Q , then click Move cursor to mouse click position Ctrl + Z Suspend CLI and return to shell, use fg to re-open External Editor Mode Use .edit or \e to open a query in an external text editor. When entered alone, it...order). If none are set, vi is used. Using Read-Line If you prefer, you can use rlwrap to use read-line directly with the shell. Then, use Shift + Enter to insert a newline and Enter to execute the query: rlwrap --substitute-prompt="D " duckdb -batch... - https://man.mtool.work/duckdb/2.0/clients/cli/editing.html
- Deploying Quack 8412
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...tom right. Wait about two minutes for CREATE_COMPLETE . Open the stack's Outputs tab. Click the ConnectURL value to open a shell.duckdb.org session pre-wired to the new instance, or copy QuackURI and Token to connect from a local DuckDB session (see b...e instance signals once the RPC server is ready. CFN Outputs carrying the ready URI, per-instance token, and two shareable shell.duckdb.org URLs ( QueryURL , ConnectURL ). For Maintainers The CloudFormation template, AMI baking process, and per-region... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
DuckDB 2.0 Documentation / man.mtool.work