It turns out DuckDB can load Latin-2 encoded CSV files just fine with the combination of iconv and the shellfs extension.

My post on DuckDB vs. wc received a lot of feedback. Based on these, I ran a few more experiments to see how DuckDB stacks up against parallelized wc and grep/ripgrep on Linux.

I wrote up my results in a blog post.

TL;DR: it depends but DuckDB is still pretty fast!
szarnyasg.org/posts/duckdb...

3) The ts command adds a timestamp at the beginning of each line. On macOS, it's available in the moreutils package on Homebrew.

2) A single sed command can include multiple search and replace pairs separated by semicolon. This makes sed commands *even less readable*, so use it with caution.

1) The bat tool – an alternative to cat – prints the newline characters if it's invoked with the -A switch. This output mode reveals whether a file is using CR/LF or LF newlines (or both).