JSqsh is a Java reimplementation of a console based (i.e. non-graphical) database query tool called sqsh. Jsqsh combines the ability to run SQL queries against any database with a JDBC driver along with much of the functionality of a Unix shell, such as piping the results of queries out to external programs (grep, more, etc.), expanding variables, redirecting output to files, command line editing, tab-completion of object names, and more.
|Tags||Database Front-Ends Desktop Environment tools|
|Operating Systems||Windows POSIX Unix|
Release Notes: This version contains a sizable number of features and improvements, including support for a new line editing mechanism (JLine) that no longer requires a shared library to function, several new display styles, additional built-in driver definitions, and binaries for Windows 64-bit.
Release Notes: After a sizeable hiatus, 1.3 is finally released. This version sports s number of bugfixes as well as improved support for newer JDBC data types and features, and improved support for DB2, Oracle, and Microsoft SQL Server.
Release Notes: This release adds the ability to manage (add/remove/delete/edit/list) connection information to make managing of complex database environments easier, the ability to redirect the output of one session to another session, and a facility to execute prepared SQL or stored procedures using data contained in CSV files (similar to mail-merge in a word processor). Finally, it includes a number of critical bugfixes over version 1.1.
Release Notes: This release has a number of new features and bugfixes, including commands to automatically generate SELECT, INSERT, and CREATE TABLE statements, and to display output in a variety of graphical (GUI) formats. Command line option handing has been greatly improved and expanded, and tab completion of SQL statements has been augmented to recognize additional SQL keywords.
Release Notes: This release includes improvements to tab completion of object names, the ability to generate INSERT statements from a result set, support for more JDBC datatypes, and smarter parsing of SQL for semicolon statement completion.