Welcome to DBEclipse.org DBEclipse.org is a plugin for Eclipse which presents Sybase®, MS SQL Server®, IBM DB2® and Oracle® databases through a web interface.   The current version is downloaded and installed by directing the Eclipse "Help/Software Updates" page to the site http://www.dbecplise.org. To start the application after installation press the button on the toolbar.   The key feature of "jSQL" (the web application the plugin hosts) is that any references to tables in the source code browser are hyperlinked so that the source of the related object can be viewed with a single click.   "jSQL" is also an interactive SQL client for all sever types displaying data in an HTML table or by web export to Excel®. It includes a full database object browser - showing procedure, view and table definitions (with foreign key constraints also hyperlinked.) All SQL is saved in a history. The plugin saves it's state and will reconnect to servers on restart.   Other key features for Sybase users include a stored proc optimizer which reformats "showplan" output alongside the SQL executing for review of query plans, a graphical server monitor which shows all processes and locks on a server in real time and a SQL parser which will hyperlink all inserts, deletes and updates (by column) of an object.   Usability however is the main goal of "jSQL" which is the product of ten years as a database developer growing progressively more and more frustrated with the existing tools on the market. Developed entirely in Java using JDBC the interface is simple an uncluttered. If you can browse the web, you can access and develop code on a database.   Configuration of DBEclipse is simple. For Sybase®, DBEclipse parses the standard "sql.ini" file found in the %SYBASE%\ini directory or your PC. For other server types a simple name,host:port/DB format is used in the files "db2.ini", "oracle.ini", "sqlserver.ini" in the "C:\Documents and Settings\%USER%" directory of your PC. The DB2 configuration ini file accepts an optional third parameter for the Kerberos principal if required.   For further information consult the online documentation built into the application or get in contact with us on the DBEclipse blog. To purchase DBEclipse for use in an organisation contact us at .   Client-Client Applications - Web 2.1 beta? In setting out to create a new database client we elected not to pass along the very well trodden roads of "Thick Client" or "Client Server" application development. "Thick client" has problems of portability and complexity while "Client Server" is frequently troubled by performance.   DBEclipse takes a "third way" where it runs as a web application but the server runs on the client PC. This combines the ease of development and usability of web interfaces with the ease of installation of a client based solution. The embedded web server was easy to write in Java and can communicate with network resources exactly as would a normal "middle tier". The missing component was a Java host on the client which is conveniently provided by the Eclipse IDE for "jSQL".   If you are interested in this greatly simplified means of developing plugins for Eclipse, the source for the plugin is included in the release and is just a version of the org.eclipse Web Browser plugin slightly modified to run the server containing the application in a thread and browse to the app's home page. The tabbed interface is implemented in JavaScript.   We would go further however and suggest this may be a interesting candidate architecture to develop Web 2.0 applications in general.   Web 2.0 or AJAX applications are frequently dogged by the intense interactivity they have with their hosting server. If the server where running on the client this could improve their usability substantially. To acheive this the development and deployment activities are separated. The "jSQL" servlet was developed on a conventional web server under UNIX. An application jar is then prepared and packaged into the plugin.   Eclipse is one example of a Java host for application deployment. An interesting alternative is a signed "Java applet" which can be hosted in any Web Browser. "jSQL" is available in this format at DBExplorer.com.   Acknowledgements & Licensing DBEclipse is free for individual use only but makes use of Open Source and the freely distributable versions of proprietry software from Oracle and IBM the details of which can be viewed by clicking here. You'll be prompted to complete the licensing process online after installation.