Using DuckDB in the Terminal (vim-dadbod)

by sspaeti 5 months ago

macOS ◆ xterm-256color ◆ zsh 563 views

My favorite SQL IDE, vim-dadbod, and vim-dadbod-ui, now supports DuckDB as a database (besides many other Big Query, ClickHouse, Impala, jq, MongoDB, MySQL, Oracle, query, PostgreSQL, Presto, Redis, SQL Server, SQLite), all within my favorite editor, (neo)vim.

This short video showcases how to open an interactive DuckDB database create some tables and query them. These could also be replaced with reading from S3 or any other source that DuckDB supports, all within the comfort of the terminal.

More by sspaeti

Quickly increment column of numbers with Vim 01:23

by sspaeti 2 years ago

data base querying in vim 01:28

by sspaeti 1 year ago

I implemented the Screener from Hey in (Neo)Mutt 05:53

by sspaeti 1 year ago

How I upload to my Public Second Brain 00:46

by sspaeti 2 years ago

See all

You can download this recording in asciicast v2 format, as a .cast file.

Download

Replay in terminal

You can replay the downloaded recording in your terminal using the asciinema play command:

asciinema play 663546.cast

If you don't have asciinema CLI installed then see installation instructions.

Use with stand-alone player on your website

Download asciinema player from the releases page (you only need .js and .css file), then use it like this:

<!DOCTYPE html>
<html>
<head>
  <link rel="stylesheet" type="text/css" href="asciinema-player.css" />
</head>
<body>
  <div id="player"></div>
  <script src="asciinema-player.min.js"></script>
  <script>
    AsciinemaPlayer.create(
      '/assets/663546.cast',
      document.getElementById('player'),
      { cols: 189, rows: 46 }
    );
  </script>
</body>
</html>

See asciinema player quick-start guide for full usage instructions.

While this site doesn't provide GIF conversion at the moment, you can still do it yourself with the help of asciinema GIF generator utility - agg.

Once you have it installed, generate a GIF with the following command:

agg https://asciinema.org/a/663546 demo.gif

Or, if you already downloaded the recording file:

agg demo.cast demo.gif

Check agg --help for all available options. You can change font family and size, select color theme, adjust speed and more.

See agg manual for full usage instructions.