Judge0 • Feature Review • SQLite

by hermanzdosilovic 4 years ago

GNU/Linux ◆ xterm-256color ◆ bash 3296 views

Since Judge0 v1.7.0 you can run SQL scripts using SQLite DBMS.

To do this, we will use Additional Files feature which allows you to send a database file named db.sqlite (required name) on which your SQL script will be run.

This example uses chinook database.

More by hermanzdosilovic

Judge0 • Sending and Receiving Raw Data 00:11

by hermanzdosilovic 4 years ago

Judge0 • Sending and Receiving Base64 Encoded Data 00:46

by hermanzdosilovic 4 years ago

Judge0 • Some Attributes for This Submission Cannot Be Converted to UTF-8 00:18

by hermanzdosilovic 4 years ago

Judge0 • Supported Languages in v1.5.0 00:12

by hermanzdosilovic 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 326975.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/326975.cast',
      document.getElementById('player'),
      { cols: 103, rows: 39 }
    );
  </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/326975 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.