It can be used with many different databases and in place of other command line tools such as MySQL's mysql-client, PostgreSQL's psql, MS-SQL and Oracle's sqlplus.
It has features such as multiple connections, multi-database interfacing, subselects for all databases, regardless of whether the database has native subselects or not, and much more.
Here are some key features of "sql++":
Tested supported databases/non-DBs:
· IBM DB2
· Excel spreadsheets
Untested, theoretically supported:
What's New in This Release: [ read full changelog ]
· Added -S option for mysql connections to have "safe" connections. See mysql's --safe-updates.
· Introducing some Microsoft SQL support using the Sybase driver.
· Added better handling of different database drivers when errors arise.
· Fixed a bug where with some database types you couldn't specify a port.
· Fixed a double-line parsing inefficiency.
· Fixed an Oracle bug which showed all column names for all Oracle tables with the same table name to display when using field name auto-completion for a specific table.