Eclipse Data Tools Platform

Published on by
Comment

In the summer of 2005 was the Data Tools Project launched.

The Data Tools Platform (DTP) project will include extensible frameworks and exemplary tools, enabling a diverse set of plug-in offerings specific to Particular data-centric technologies and supported by the DTP ecosystem. In the spirit of Eclipse, the project will be guided by the following values:

Vendor Neutrality
Extensibility
Community Involvement
Transparency
Agile development

It's easier this is a collection of plugins that the creation of DB-specific tools. To Here's a quick / nebulous News ;)
Quote:

[...] Its elements include, among other things, using templates generated database driver, database connection profiles, database tables and SQL-Explorer-tools - in other words, it makes the connection to the backend database [...]

What are the templates generated by the database driver?

In January 2007, an author expressed in this article the hope that Eclipse provides for quality and innovation and the DB Tools launches market on the move ... Now, in 2008 passed the half but hit the DTP is not so far? Has anyone used it already?

And adds: "free cross platform database tool"

Published on by
Comment

In java lobby I'm on the Epictetus Database Manager encountered:

Epictetus - free cross platform database tool. Currently supports Oracle, MSSQL, MySQL, Firebird, HSQLDB. Latest version is 0.3 beta. It's not final release but you can download and use it already

It is a further DB tool, but this time based on the Netbeans RCP . This species seems to be somewhat less ;) But that does not change the fact that it is seemingly de rigueur that every developer tool creates his own in this area ... especially among Java developers!

Instant SQL Formatter

Published on by
Comment

On this side there is a nice online SQL Formatter:
Instant SQL Formatter, where it can also be downloaded and integrated into your applications. There are versions for NET, COM and VCL.

The website says:

General SQL Parser adds powerful sql processing capability to your program, including sql syntax check, beautify complex sql code with lots of customizable format options, identify various database objects tested as table, column, constraints in sql scripts, modify and rebuild sql on the fly , translate sql expression into a binary expression tree that ready for your further processing investigated as creating filter, and you take full control of sql with detailed parse tree of the whole input sql.

General SQL Parser is designed to deal with SQL statement used by different Database Such as Oracle, DB2, Informix, Sybase, Postgres, MySQL and so on. And it conforms to most of the entry-level SQL99 Standard.

Mogwai ER Designer

Published on by
Comment

The Mogwai ER Designer is an ER modeling tool like ERWin example. It is open source and is hosted at sourceforge.net. The website says:

Mogwai The Earth Signer is a entity relation modeling tool tested as ERWin and co. The only difference is that it is open source and does not cost anything. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from design to database schema and code generation. This tool was also designed to support a flexible plug in architecture, to extend the system by simply installing a new plug in. This way, everybody can implement new features and tools to make Earth Signer fit the requirements.

Earth Signer NG is based on Java and can be run on Windows and Unix systems
has a powerfull WYSIWYG for physical database design
handles tables, relations, indexes and comments
supports subject areas
supports MySQL, Oracle, Microsoft SQL Server and Postgres
creates the SQL DDL statements for schema creation
has an integrated schema version control system
can generate schema migration scripts for every change
stores the database definition as XML files for further processing
can export the database schema as GIF, BMP, JPEG or EPS files has an integrated reverse engineering module for existing schemas it is based on GPL license support is available by authors and newsgroups

Two SQL Developer?

Published on by
Comment

For several months (years?), Oracle tool SQL Developer free of charge. The interesting thing is: There is another Java-based query and admin tool available with the same name: SQL Developer - The Universal Database Frontend . This tool has been around since 2001! Has "taken" here the stronger the simple name?

Squirrel SQL and NetBeans?

Published on by
A

Squirrel SQL is a very good Java based SQL client. This tool uses JDBC to connect to any database. The only requirement: A JDBC driver must be present.
Squirrel is open source and is at SourceForge hosted. Life into the project was launched by Colin Bell, I think it was in 2001. In any case, says the copyright of the entry in the class: Main.java.
A few years later, Gerd Wagner then intervened into the action. Colin and Gerd are still the project admins at SourceForge. The operation and performance are great and the possibilities are very extensive. Could be noticed at work that the squirrels attack a few years and convinced by a good many small features. Now is the end of the adulation ;)
Unfortunately, the UI could not keep pace with progress. It seems a bit in the years come:

SQuirreL SQL UI

But it's open source. So do not complain: tackling! No sooner said than done. To avoid reinventing the wheel, I've fallen in NetBeans. Specifically, on the NetBeans platform . Here is an excerpt of the description from Wikipedia:

The NetBeans Platform is an application runtime - a basis for a generic large desktop application. Most applications have similar requirements: menus, document management, change settings and so on. The NetBeans platform created for example, menus or generates code for saving settings. The developer must use his code as a NetBeans module, create and add this to the platform to create a platform-independent application. The NetBeans platform is designed to allow developers to concentrate on the business logic as essential tasks, saving time and effort.

More details get updated very often here .

Squirrel uses already currently a small part of the NetBeans platform. The SQL editor is based on the NetBeans editor. It provides SQL code completion and automatic syntax checking. It has useful shortcuts for bookmarks with Ctrl-Space, dissolve the IntelliSense function (auto-completion of SQL commands).

My first try with port-Squirrel and Netbeans can see in the pictures below:

SQuirreL on NetBeans: SQL History

SQuirreL on NetBeans: JDBC Panel

SQuirreL on NetBeans: Session Panel

To achieve this state intervention in many places in Squirrel's source code were necessary. Unfortunately, often working directly with JInternalFrames, which prevented a lean adjustments by a few refactorings. Rocketed to the current state I can tell the size of the package "Squirrel" in the considerable height.
Because of the great effort I am of NetBeans this way is no longer quite so sure. The cost \ benefit is not in a good relationship. Only when more features of the NetBeans platform would be used, it would look better again. NetBeans has a fine example module system, an auto-update Mechnismuss, shortcut management, and more. Squirrel could offer a complete port on the NetBeans Platform hightlighting example syntax for XML. Even the well-known problem with very large SQL statements in SQL Editor would be solved. However, this adaptation is still an unknown quantity for me. The Squirrel's editor based on the NetBeans editor already, but this is a very old version. Especially since NetBeans 6.0 has been in use \ integration of the editor, did some (project Schliemann)
But, I'm starting to polish the front end of the mission. So back on topic: I will go and follow the NetBeans way but not looking for an alternative.
to miss the squirrel a fresh UI ;)
Those interested in the sources, can report you!

Hooray! A SQL blog! ;)

Published on by
Comment

Yet another new blog? How original ;) But this time about SQL!

Ok, there are probably hundreds already ... mmhhh. But these reservoirs on page MY SQL and everything around it! And THAT did not exist before.

And what you, the gentle reader?
I will separate into products, software, ideas, or just things I have noticed about SQL or employ me now, my two cents. Of course, contributes in the hope that one or another of an illuminating comment.

The beginning is done ...