Demo of my little sqlmd function to generate markdown tables from SQLite CLI queries

by dann 7 years ago

macOS ◆ xterm-256color ◆ bash 1884 views

This is a command-line function I use when blogging about how to do SQL. Write a query and get a result in Markdown-friendly table format

https://gist.github.com/dannguyen/0e6bfa466dec22d198b958059e1947b3

More by dann

untitled 00:05

by dann 7 years ago

Using ack and regex to convert unstructured NASA GISS temperature data to CSV 01:22

by dann 7 years ago

Don't play this version, play this one instead: https://asciinema.org/a/85999 00:23

by dann 7 years ago

Using ack to grep through Secretary Hillary Clinton's released emails (truncated) 00:23

by dann 7 years ago

See all

You can download this recording in asciicast v1 format, as a .json file.

Download

Replay in terminal

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

asciinema play 89573.json

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/89573.json',
      document.getElementById('player'),
      { cols: 98, rows: 28 }
    );
  </script>
</body>
</html>

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

While this site doesn't offer 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 run the following command to create GIF file:

agg https://asciinema.org/a/89573 89573.gif

Or, if you already downloaded the recording file:

agg 89573.json 89573.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.