News for hackers. Stuff that matters.
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.
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!
Re:Usql – A universal command-line interface for SQL databases by bloat on Friday March 03, 2017 @04:15AM (#13781666)
Here's an oldish program that does the same thing in Java using JDBC.

https://github.com/neurolabs/henplus