The Sclera visual shell provides an interactive interface to manage and analyze your data, and also explore the Sclera metadata. The command-line is a richer alternative to the Sclera Command Line Shell in that it supports data visualization extensions to ScleraSQL.

Sclera Visualization

The shell can be started by executing the command


where $SCLERA_HOME is the directory where Sclera is installed.

The command starts a Sclera HTTP Server at port 9000. To start the server at another port instead, please specify the port explicitly as follows:

$SCLERA_HOME/bin/ -port <port>

In the following, we will assume the default port, i.e. port 9000.

When started for the first time, the command may also try to download the Sclera License and install Sclera Visualization component if not already available.

Logging In

The shell is available at http://localhost:9000/shell – please replace localhost by the server address while connecting remotely.

Connecting to the server takes you to the login page, where you need to add the user credentials (email and password, if needed). Successful login shows the sclera visual shell.

Using the Shell

You can use the shell by submitting your SQL commands in the command box. The commands can span multiple lines, and are submitted by pressing “Control + Enter” or pressing the the “Run” button below.

You can navigate through the history by pressing Page-Up and Page-Down to display the previous and next commands in order. You can also copy and paste as usual.

All ScleraSQL commands and and metadata management commands accepted by the command line shell are supported, in addition to the data visualization extensions to ScleraSQL.

Clicking on “Examples” at the top of the page takes you to the Sclera Visualization Examples page. Clicking on any “live demo” button takes you to a demo of the chosen visualization. You can copy examples from that page to run then locally in your shell.

Logging Out

You can logout by clicking at “Logout” in the panel at the top of the page.

Related Documentation