Home Code Other Software

Table of Contents

Introduction

SQLShell is a Scala-based SQL command-line tool, similar in concept to tools like Oracle’s SQL Plus, the PostgreSQL psql command, and MySQL’s mysql tool.

Some features at a glance

In short, SQLShell is a SQL command tool that attempts to provide some powerful features that are consistent across all supported databases and platforms.

Getting SQLShell

Binary releases

Prerequisites

SQLShell requires:

As of version 0.2, SQLShell comes bundled with an appropriate version of the Scala runtime, so you do not need to have a Scala installation to use SQLShell.

The graphical installer

Install SQLShell via the graphical installer jar, available in the downloads area:

java -jar sqlshell-0.8.1-installer.jar

This command will install SQLShell, a front-end Unix shell script or Windows BAT file, and all the dependencies. The installer jar file is signed with my PGP key.

Building from source

You can also install SQLShell from source.

Prerequisites

Building SQLShell requires SBT (the Simple Build Tool), version 0.10.

Getting the source

Either download the source (as a zip or tarball) from http://github.com/bmc/sqlshell/downloads, or make a local read-only clone of the GitHub repository using one of the following commands:

$ git clone git://github.com/bmc/sqlshell.git
$ git clone http://github.com/bmc/sqlshell.git

Building

Once you have a local sqlshell source directory, change your working directory to the source directory, and type:

Then, run

sbt update

to pull down the external dependencies. After that step, build SQLShell with:

sbt compile package

The resulting jar file will be in the top-level target directory.

To build the installer, you currently need to have the IzPack product installed, and you need to set IZPACK_HOME set to its top-level directory. Once that’s in place, you can build the installer with

sbt installer

Documentation

Consult the User’s Guide for complete documentation on SQLShell. The User’s Guide is also shipped with the SQLShell source and can be installed via the binary graphical installer.

If you’re of a mind to do so, you can also peruse the change log.

Reporting Bugs

If you encounter a bug in SQLShell, freel free to open an issue on the issues page. In the issue, please include:

In addition, enable SQLShell stack traces, as show below; if SQLShell dumps a stack trace, please include it in the issue.

Enabling stack traces

To enable stack traces, set the SQLShell stacktrace variable:

db> .set stacktrace on

SQLShell is copyright © 2009-2012 Brian M. Clapper is released under a BSD license. See the accompanying license file.

Patches

I gladly accept patches from their original authors. Feel free to email patches to me or to fork the GitHub repository and send me a pull request. Along with any patch you send: