Java Open Source Projects Directory

...dedicated into Java open source projects

  • Increase font size
  • Default font size
  • Decrease font size
SQL Clients

jisql

A command line interactive SQL tool that can connect to any database with a JDBC driver. By default it works like the Sybase isql or MS/SQL's isql/osql commands but can also behave like the Oracle's sqlplus or PostgreSQL's psql.

 

liquibase

LiquiBase is a DBMS-independent library for tracking, managing and applying database changes. All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control. LiquiBase has the following features:

 * Supports merging of changes from multiple developers
 * Works well with code branches
 * Allows you to manage production data as well as various test datasets
 * Works in an environment where multiple machines will be attempting to migrate the database concurrently
 * Supports automated change-applying or generation of SQL scripts that can be approved and applied by a DBA
 * Supports rolling back changes
 * Can create database "diff"s and can generate change logs from them

 

queryform

QueryForm is a robust Java application that provides a powerful GUI front end for JDBC-enabled databases. It creates forms on-the-fly through which you can query tables and browse the results with just a few keystrokes or mouse clicks. It also lets you insert, update and delete table rows without typing any SQL statements.

 

guam

GUAM is, as the name implies, a GUI frontend to allow easy administration of MySQL users. It is written in Java and uses the Swing toolkit. Since it is a pure Java application, it is completely cross-platform and should work on any platform that has a full Java implementation (and maybe even some of the cut-down implementations). GUAM is released under the GNU General Public License (GPL).

 

sql-workbench-j

SQL Workbench/J is a DBMS independet frontend for SQL databases. It can be used in batch mode and has strong export and import capabilities. It also offers some extensions to SQL (Variable substitution, BLOB support with local filenames) that try to unify handling SQL databases. It can copy table data directly between two different servers (batch and GUI)

 

sqlminus

SQLMinus is an SQL Client with many developer-friendly features

 

execute-query

Execute Query is an desktop sql client written in java. It includes a query editor, a table browser, import/export capabilities, a sql script generator and a visual editor.

 

isql-viewer

iSQL-Viewer is an open-source JDBC 2.x compliant database front end written in Java. It implements across multiple platforms features of the JDBC API. It does everything through a single interface. iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix. iSQL-Viewer provides a variety of tools and features to carry out common database tasks.

 


Page 2 of 4