"Streaming" MySQL—in VERTICAL MODE!

--:----:--

"Streaming" MySQL—in VERTICAL MODE!

by rmoff 5 years ago

macOS ◆ xterm-256color ◆ bash 1296 views

What dark magic is this?

🆒 ➡ If you switch ; for \Gyou get the results back VERTICALLY!

watch -n 1 -x \
  docker-compose exec mysql bash -c '\
    echo "SELECT * FROM ORDERS ORDER BY CREATE_TS DESC LIMIT 5\G" | \
    mysql -u root -p$MYSQL_ROOT_PASSWORD demo'

More by rmoff

Streaming RabbitMQ into Kafka 00:17

by rmoff 5 years ago

Kafka Connect dynamic log level adjustment 00:23

by rmoff 5 years ago

RabbitMQ -> Kafka -> Postgres 00:27

by rmoff 5 years ago

KSQL demo - STREAM-STREAM join 00:15

by rmoff 6 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 245480.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/245480.cast',
      document.getElementById('player'),
      { cols: 72, rows: 29 }
    );
  </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/245480 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.