Results of 1 - 10 of about 12 for stdout (0.002 sec.)
- CLI Charting with YouPlot 13849
- 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
...ly generate various types of plots including bar, line, histogram and scatter. With DuckDB, you can write to the console ( stdout ) by using the TO '/dev/stdout' command. And you can also write comma-separated values by using WITH (FORMAT csv, HEADER)...c, you can use: brew install youplot Run uplot --help to ensure you've installed it successfully! Piping DuckDB Queries to stdout By combining the COPY...TO function with a CSV output file, you can read data from any format DuckDB supports and pipe it...GROUP BY 1 ORDER BY 2 DESC LIMIT 10" Finally, wrap the SELECT in the COPY ... TO function with an output location of /dev/stdout . The syntax looks like this: sql COPY (⟨query⟩) TO '/dev/stdout' WITH (FORMAT csv, HEADER); The full DuckDB command below... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Logging 10771
- 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
...lemented in core DuckDB. Log storage Description memory Log to an in-memory buffer (default in clients other than the CLI) stdout Log to the stdout of the current process (in CSV format) file Log to (a) csv file(s) shell_log_storage Print log messages...storage. This means that switching the log storage may influence what is returned by the duckdb_logs function. Logging to stdout CALL enable_logging(storage = 'stdout'); Logging to File CALL enable_logging(storage = 'file', storage_config = {'path': '...ored separately with context_id s referencing the context information. Log storage Normalized memory yes file configurable stdout no For file storage, you can switch between normalized and denormalized by providing a path to a directory (for normalized... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Command Line Client 9834
- 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.
...would other SQL statements. INSTALL fts; LOAD fts; For details, see the Extension docs . Reading from stdin and Writing to stdout When in a Unix environment, it can be useful to pipe data between multiple commands. DuckDB is able to read data from stdi...n as well as write to stdout using the file location of stdin ( /dev/stdin ) and stdout ( /dev/stdout ) within SQL commands, as pipes act very similarl.../dev/stdin as a file location. cat test.csv | duckdb -c "SELECT * FROM read_csv('/dev/stdin')" woot 42 43 To write back to stdout, the copy command can be used with the /dev/stdout file location. cat test.csv | \ duckdb -c "COPY (SELECT * FROM read_csv... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Command Line Arguments 8507
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...that the ~/.duckdbrc is read and executed first (if it exists) -format Format SQL read from stdin , writing the result to stdout -format-file FILENAME Format the SQL in FILENAME , writing the result to stdout -init FILENAME Run the script in FILENAME... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Profile and Monitor 8154
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...t_profiling_info() : use duckdb::Connection; let conn = Connection::open_in_memory()?; // Do not print profiling output to stdout after each query (the default when profiling is enabled). conn.execute("PRAGMA enable_profiling = 'no_output'", [])?; conn... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- Dot Commands 7994
- 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
...ult without truncating. Useful for navigating with the pager .log ⟨FILE/off⟩ Turn logging on or off . FILE can be stderr / stdout .manual ⟨FUNCTION⟩ Show the manual page (signatures, descriptions and examples) for a SQL function. See the manual section...existing database and reopen FILE . Options: --new , --nofollow , --readonly , --sql .output ⟨FILE⟩ Send output to FILE or stdout if FILE is omitted .pager ⟨OPTIONS⟩ Control pager usage for output. See the paging section for details .print ⟨STRING...⟩... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Profile and Monitor 7994
- Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information
...er db.Close() conn, err := db.Conn(context.Background()) check(err) defer conn.Close() // Do not print profiling output to stdout after each query. _, err = conn.ExecContext(context.Background(), `SET enable_profiling = 'no_output'`) check(err) // Run... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- Benchmark Suite 7924
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...: build/release/benchmark/benchmark_runner benchmark/micro/nulls/no_nulls_addition.benchmark The output will be printed to stdout in CSV format, in the following format: name run timing benchmark/micro/nulls/no_nulls_addition.benchmark 1 0.121234 bench... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- SQLite Extension 7853
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...guration parameters. Name Description Default sqlite_debug_show_queries DEBUG SETTING: print all queries sent to SQLite to stdout false Supported Operations Below is a list of supported operations. CREATE TABLE CREATE TABLE sqlite_db.tbl (id INTEGER, n... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- MySQL Extension 7782
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...r not to convert BIT(1) columns to BOOLEAN true mysql_debug_show_queries DEBUG SETTING: print all queries sent to MySQL to stdout false mysql_enable_filter_pushdown Whether or not to use filter pushdown (without predicate analyzer) true mysql_enable_tr... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
DuckDB 2.0 Documentation / man.mtool.work