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:
· MySQL
· MSSQL
· PostgreSQL
· Oracle
· IBM DB2
· Sybase
· CSVs
· Excel spreadsheets
Untested, theoretically supported:
· Adabas
· DBMaker
· Fulcrum
· Illustra
· Informix
· Ingres
· InterBase
· JDBC
· LDAP
· ODBC
· Access
· Ovrimos
· Empress
· PrimeBase
· Solid
· Unify
· XBase
· SearchServer
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.