SQL console

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):

sqlconsole.png

Continue reading SQL console

New releases

Just a few words about the 3.1.2 release of Libgda and Libgnomedb and mergeant 0.67. The 3.1.2 is the second unstable version which brings a few new features and a lot of improvements and bug fixes compared to 3.1.1; the new features are stabilizing…

Mergant has not evolved a lot lately (my efforts are currently essentialle spend on Libgda), and this new version mainly allows one to test the improvements in Libgda/Libgnomedb.

The source code is available from the GNOME FTP server: