Projects / JSqsh

JSqsh

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
Licenses
Operating Systems
Implementation
Translations

Recent releases

  •  19 Mar 2011 22:07

    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.

    •  06 Aug 2010 19:34

      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.

      •  03 Apr 2008 20:12

        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.

        •  19 Feb 2008 18:13

          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.

          •  11 Jan 2008 21:24

            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.

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.