Having used PostgreSQL’s psql console tool a lot in the past, I got used to its very good features (short commands to display info such as \dt, paged output when it contains more lines than current terminal size, (basic) HTML output for quick reports,…)
Those features are not always available in the SQL console of the other DBMS systems I’ve come to use, so I decided some time ago to write a new SQL console using Libgda, and it’s now useable with some nice features:
- partial implementation of some of the PostgreSQL’s psql SQL console (some short commands, paged output, HTML export mode,…)
- multiple simultaneous connections (with the possibility to change the current connection used to issue SQL commands)
- possibility to bind several connections into one and issue cross-connection SQL statements (for example a SELECT using tables from 2 different connections)
- support for all the DBMS types supported by Libgda
Here is a sample session (where a connection named cnc0 is opened to the SalesTest defined data source):
Great concept, and really loved the idea to do cross-connection consults.
Do you have the sources available?
Best regards 😀
It’s in the tools/ dir of the Libgda’s sources version 3.1.2, available at http://ftp.gnome.org/pub/GNOME/sources/libgda/3.1/libgda-3.1.2.tar.bz2
Vivien
That’s a really great looking tool. I assume it will work with anything libgda will?
Yes, right: it is possible to open connections to any database supported by Libgda: currently works fine with PostgreSQL, MySQL, SQLite, Oracle, Firebird, MDB (MS Access) and BDB (though by default you’ll only get some binary data).