iiinova — where your digital self keeps evolving

Gabor Szarnyas

@szarnyasg.org

Head of DevRel at DuckDB Labs

Gabor Szarnyas @szarnyasg.org · 26/05/2026

I will be speaking at Ubuntu Summit 26.04 on Thursday about DuckDB. My presentation will cover DuckDB at three different deployment models: as a CLI tool, as a portable database, and as a server. The event is streamed but requires registration – see ubuntu.com/summit

0111

Gabor Szarnyas @szarnyasg.org · 07/03/2025

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

1161

Gabor Szarnyas @szarnyasg.org · 04/12/2024

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...

1132

Gabor Szarnyas @szarnyasg.org · 30/11/2024

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

000

Gabor Szarnyas @szarnyasg.org · 30/11/2024

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.

100

Gabor Szarnyas @szarnyasg.org · 30/11/2024

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).

100