The sqlIDE project goals is to develop a freely available, GNU GPLed, easy to use sql IDE in Java/Swing for many simultaneous server backends. The idea is that you could have, say pgSQL, mySQL, Sybase and MSSQL servers and be able to do work on all of them using the same interface.
The program is compatible with any JDBC driver. It will require the JAR for the driver, which you can provide on startup from a user-friendly wizard.
The program has been tested to work under the following servers:
You can find a user's guide here.
In development. The base system works and the plugin API is starting to solidify. The plugins are now properly separate to make it easy to develop new ones. The default plugins are a query runner with support for viewing Clobs and a Table editor.
A plugin manager is in the process of being written that currently shows the loaded plugins and their descriptions. It will eventually allow you to install new plugins and remove/disable plugins.
So far the following plugins are available, and are bundled within the JSqlIDE Package:
The interactive SQL Panel is the first obvious panel that had to be created. It features syntax highlighting of the SQL code and output on table or text format, as well as a Clob viewer when appropriate.
The table creation panel can create (and alter, some day) tables. It basically works as a grid where the user creates or changes an existing table.
There are other future panels I have basic ideas for, like stored procedure/trigger editing, maybe a visual query, etc.
Here are some screenshots. Everybody loves screenshots!
To build, you will need Ant Version 1.5, which you can find at The Jakarta Project
To run, download the JAR and simply execute using "java -jar jsqlide"
