SQL::Shell 1.13

SQL::Shell is a command interpreter for DBI shells.
SYNOPSIS
use SQL::Shell;
#Initialise and configure
my $sqlsh = new SQL::Shell(%settings);
$sqlsh->set($setting, $new_value);
$value = $sqlsh->get($setting);
#Interpret commands
$sqlsh->execute_command($command);
$sqlsh->run_script($filename);
SQL::Shell is a command-interpreter API for building shells and batch scripts. A command-line interface with readline support - sqlsh.pl - is included as part of the CPAN distribution. See < SQL::Shell::Manual > for a user guide.
SQL::Shell offers features similar to the mysql or sql*plus client programs but is database independent. The default command syntax is arguably more user-friendly than dbish not requiring any go, do or slashes to fire SQL statements at the database.
Main features:
- issuing common SQL statements by simply typing them
- command history
- listing drivers, datasources, tables
- describing a table or the entire schema
- dumping and loading data to/from delimited text files
- character set conversion when loading data
- logging of queries, results or all commands to file
- a number of formats for display/logging data (sql, xml, delimited, boxed)
- executing a series of commands from a file
You can also install custom commands, rendering formats and command history mechanisms. All the commands run by the interpreter are available via the API so if you dont like the default command syntax you can replace the command regexes with your own.
Its been developed and used in anger with Oracle and mysql but should work with any database with a DBD:: driver.