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

RSS Recent releases

  •  20 Mar 2011 08:00

    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 22:16

      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 12: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 10: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 13: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

      ccextractor

      A fast closed caption (subtitles) extractor.

      Screenshot

      Project Spotlight

      Text-Tokenizer

      A Perl module for lexical analysis/parsing of text files.