Setting up a SQL database with Encore

$ ls                                                                │$ curl http://localhost:4060/greet.Person -d '{"Name": "Jane"}     encore.app      go.mod          go.sum          greet               │                                                                   $ cat greet/migrations/1_create_table.up.sql                        │                                                                   CREATE TABLE person (                                               │                                                                       name TEXT PRIMARY KEY,                                          │                                                                       count INT NOT NULL                                              │                                                                   );                                                                  │                                                                   $ encore run                                                        │                                                                   Running on http://localhost:4060                                    │                                                                   2:04PM INF registered endpoint endpoint=Person service=greet        │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                                                                                       │                                                                   [encore] 0:bash*                                                                                   "eandre: bash - bash" 14:04 12-Apr-21

--:----:--

Setting up a SQL database with Encore

by eandre 4 years ago

macOS ◆ xterm-256color ◆ fish 2182 views

https://encore.dev is a Go backend framework with superpowers. This video shows how to set up and use SQL databases.

More by eandre

Creating an app with Encore 0:24

by eandre 4 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 406695.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/406695.cast',
      document.getElementById('player'),
      { cols: 136, rows: 25 }
    );
  </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/406695 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.