Using DuckDB in the Terminal (vim-dadbod)

by sspaeti
Download
.cast - original recording .txt - plain text version .gif - animated GIF
macOS • xterm-256color • zsh 1750 views

My favorite SQL IDE, vim-dadbod, and vim-dadbod-ui, now support DuckDB as a database (besides many others, including BigQuery, ClickHouse, Impala, jq, MongoDB, MySQL, Oracle, PostgreSQL, Presto, Redis, SQL Server, and 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.

Check out the setup and more details at https://www.ssp.sh/brain/query-databases-in-vim-vim-dadbod.

Querying Bluesky with DuckDB and SQL directly from terminal: https://www.ssp.sh/brain/querying-bluesky-with-duckdb-and-sql/

More recordings by sspaeti

Browse all

data base querying in vim 1:28

by sspaeti

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

by sspaeti

Quickly increment column of numbers with Vim 1:23

by sspaeti

Using MCP in Neovim with direct query with MotherDuck Queries 2:43

by sspaeti
Share this recording
https://asciinema.org/a/663546
Copied!

Append ?t=30 to start the playback at 30s, ?t=3:20 to start the playback at 3m 20s.

See sharing docs for more link customization options.

Embed as image link

Use snippets below to display a preview image linking to this recording.
Ideal for places where scripts are not allowed, such as project README files.

HTML: 

<a href="https://asciinema.org/a/663546" target="_blank"><img src="https://asciinema.org/a/663546.svg" /></a>
Copied!

Markdown: 

[![asciicast](https://asciinema.org/a/663546.svg)](https://asciinema.org/a/663546)
Copied!

Embed the player

If you're embedding on your own page or on a site which permits script tags, you can use the full player widget:

<script src="https://asciinema.org/a/663546.js" id="asciicast-663546" async="true"></script>
Copied!

Paste the above script tag where you want the player to be displayed on your page.

See embedding docs for more player customization options.

Download this recording

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
Copied!

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="/assets/asciinema-player.css" />
</head>
<body>
  <div id="player"></div>
  <script src="/assets/asciinema-player.min.js"></script>
  <script>
    // @license magnet:?xt=urn:btih:8e4f440f4c65981c5bf93c76d35135ba5064d8b7&dn=apache-2.0.txt Apache-2.0
    AsciinemaPlayer.create(
      '/assets/663546.cast',
      document.getElementById('player'),
      { cols: 189, rows: 46 }
    );
    // @license-end
  </script>
</body>
</html>

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

Generate GIF from this recording

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
Copied!

Or, if you already downloaded the recording file:

agg demo.cast demo.gif
Copied!

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.