Druid: The Database Manager

The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information. Once the database is created, the druid can generate:

• HTML documentation: for all tables, with browsing facilities
• PDF documentation: for all tables
• Java classes: (one class for each table) that contain tables' constants (such as fields size) plus java code added by the user
• A data dictionarythat contains all tables and fields present in the database
• SQL script which contains all table definitions that can be piped to the DBMS
• And much more info...

Download

Middlegen

Are you tired of the headaches involved with editing deployment descriptors and entity bean source code? Middlegen is a free general-purpose database-driven code generation engine based on JDBC, Velocity, Ant and XDoclet. If you already have a database, you can use Middlegen to generate.

• Persistance layer with EJB (CMP 2.0)
• Persistance layer with JDO
• Persistance layer with Hibernate
• Persistance layer with Torque
• Database GUI with JSP/Struts

Developping database-driven applications with Middlegen is easy:

1. Create the database with your preferred database modeler tool
2. Configure Middlegen to access the database and read the database schema
3. Run Middlegen from Ant, and (optional) with the GUI tool, rename tables and columns, tune relationships and type-mappings
4. Generate your source code with Middlegen
5. Run XDoclet to generate the additional files like EJB homes and interfaces, and deployment descriptors
6. Compile and deploy your application

Download