Mastodawn

@doctormo I looked this up a few weeks back, and came up with #gnuplot #youplot and #dot. The last one is a file type which you basically have automatically. #Graphvis uses it to make up charts and whatnot.

I haven't gotten around to trying any of it out yet.

Mohit Sindhwani Feb 21, 2025

If you're using #DuckDB on Windows and trying to connect it to #YouPlot, the samples on https://duckdb.org/docs/guides/data_viewers/youplot use `COPY TO /dev/stdout` which does not work on #Windows.

Just start it as `duckdb [DB] -csv -s QUERY` which sends CSV outputs to stdout.

#programming #analytics

CLI Charting with YouPlot

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 piping data from stdin. It takes tab-separated (or delimiter of your choice) data and can easily 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). Installing YouPlot…

DuckDB