Re:Usql – A universal command-line interface for SQL databases
by peteretep on Friday March 03, 2017 @12:10AM
(#13780899)
It's a shame no-one has used DBI and SQL::Abstract etc to build something similar in Perl.
[ Parent
| on HN ]
Re:Usql – A universal command-line interface for SQL databases
by carl1234 on Friday March 03, 2017 @02:38AM
(#13781340)
see GNU sql, it comes with GNU parallel https://www.gnu.org/software/parallel/ "GNU sql aims to give a simple, unified interface for accessing databases through all the different databases' command line clients. So far the focus has been on giving a common way to specify login information (protocol, username, password, hostname, and port number), size (database and table size), and running queries.
The database is addressed using a DBURL. If commands are left out you will get that database's interactive shell.
When using GNU SQL for a publication please cite:
O. Tange (2011): GNU SQL - A Command Line Tool for Accessing Different Databases Using DBURLs, ;login: The USENIX Magazine, April 2011:29-32.
Re:Usql – A universal command-line interface for SQL databases
by cryptarch on Friday March 03, 2017 @01:10PM
(#13784765)
Ah, it's that GPL + nag/guilt-trip model again...
Following that rationale, why doesn't any sane person cite Matlab, R, Tex or MS Word on their publications?
Re:Usql – A universal command-line interface for SQL databases
by mlawren on Friday March 03, 2017 @10:08AM
(#13783311)
Actually someone did, in 1998 no less: https://metacpan.org/pod/DBI::Shell
Re:Usql – A universal command-line interface for SQL databases
by falsedan on Friday March 03, 2017 @02:29AM
(#13781304)
I'm sure people have (I wrote a simple MySQL/Oracle wrapper many jobs ago to help smooth out the bumps when integrating Perl products with client databases). It's a shame no one has released a Perl tool like this yet!