• Stars
    star
    123
  • Rank 290,145 (Top 6 %)
  • Language
    Perl
  • Created over 12 years ago
  • Updated over 7 years ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

An easily extensible DBI shell, perfect for a drop-in replacement to mysql-client

NAME

App::AltSQL - A drop in replacement to the MySQL prompt with a pluggable Perl interface

SYNOPSIS

./altsql -h <host> -u <username> -D <database> -p<password>

altsql> select * from film limit 4;
โ•’โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•คโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•คโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•
โ”‚ film_id โ”‚ title            โ”‚ description                
โ•žโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•ชโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•ชโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•
โ”‚       1 โ”‚ ACADEMY DINOSAUR โ”‚ A Epic Drama of a Feminist 
โ”‚       2 โ”‚ ACE GOLDFINGER   โ”‚ A Astounding Epistle of a D
โ”‚       3 โ”‚ ADAPTATION HOLES โ”‚ A Astounding Reflection of 
โ”‚       4 โ”‚ AFFAIR PREJUDICE โ”‚ A Fanciful Documentary of a
โ•˜โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•งโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•งโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•
4 rows in set (0.00 sec)

DESCRIPTION

AltSQL is a way to improve your user experience with mysql, sqlite3, psql and other tools that Perl has DBI drivers for. Currently written for MySQL only, the long term goal of this project is to provide users of the various SQL-based databases with a familiar command line interface but with modern improvements such as color, unicode box tables, and tweaks to the user interface that are fast and easy to prototype and experiment with.

INSTALLATION

It's best to use CPAN or cpanm to install this application. Should be as simple as:

$ sudo cpanm App::AltSQL

COPYRIGHT

Copyright (c) 2012 Eric Waters and Shutterstock Images (http://shutterstock.com). All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

The full text of the license can be found in the LICENSE file included with this module.

AUTHOR

Eric Waters <[email protected]>