- This topic has 3 replies, 4 voices, and was last updated 21 years, 1 month ago by
.
-
Posts
-
Any functionality that gives visual database modeling and generation of associated RDBMS-specific SQL scripts would be nice to have. Direct table and field creation support for MySQL et al would be fantastic.
Are there any existing plugins that provide examples of the functionality you’re looking for?
–Scott
MyEclipse SupportClay (http://www.azzurri.jp/en/software/clay/index.jsp) does a nice job with Visual Database Modelling.
The Quantum team has been talking about providing similar functionality.
The Clay Database Modelling tool would be nice for assisting with the Schema development & generation. The only missing component to Clay is that it currently only supports a few/ open source RDBMS products. In order to be used for many production projects, Oracle and IBM would need to be supported (and in that order based upon market share).
In addition to database modelling, or in leu of database modelling, supporting an O/R mapping tool would be great. I would say that supporting JDO would be ideal, but my personal feeling is that JDO 1.0 is not ready for mainstream usage and that you would need to wait until JDO 2.0. Hibernate, Jakarta Turbine, Jakarta OJB, and Toplink (owned now by Oracle) appear to support most of the capabilities that people need for developing large enterprise applications. Ideally, the integration with one of these products would include a graphical mapper that would generate the mapping file syntax (typically an XML file) for mapping between the java class and the database table.
