Open Source PL/SQL Code Generators

8. Mai 2005: We have discontinued SourceForge as a download place for our open source projects. You can now download these projects directly from the XLOG Technologies GmbH web site at http://www.xlog.ch/omonia.

Customizable web application generator

Build around JDBC and XML, this tool allows you to maintain visual repesentations of a database's layout, edit table's data, generate code to bind objects to tables, and export data in XML format to easely export data from one database to another.

Hades aims to become the reference open source environment for developing, validating and deploying PLUTO (Procedure Language for Users in Test and Operations) procedures.

JFolder is a web-based application development and management tool. It allows users to create applications through a web browser without writing any code. The current release includes an implementation of the Pet Store written without code.

JSQLEditor is a PL/SQL and PL/pgSQL editor plug-in for Eclipse IDE.

Model driven code generation can improve coding standards, speed, quality of development and reduce your costs. From my experience generating code from XML using XSLT is one of the best and fastest solutions. This is just the base of the framework presenting the idea, any code template can be implemented upon request. Some sample generators are present for SQL / PLSQL / C# / AnsiC / Java The main target is to generate DTO/BDO/POJO objects based on the database definitions in multiple languages aligning all technologies used by a development team. If you are willing to contribute drop a message.

Collection of various scripts to automate development with Oracle RDBMS. Includes SQL, PL/SQL and Java. Some are related to Oracle Applications Development.

Quickly define your ORM with the simple Brainstorm format, then instantly create your SQL, Java, PHP, Python, Perl, even C++, etc. code to manage all your object relationships.

spag4j is a code generator written in Java to produce Java code for accessing a stored procedure layer from a database. Currently it supports stored procedures written in an Oracle. It produces either an EJB3 Java layer or simple static access methods.

This site is intended as a location containing a suite of tools to (1) Aid in the design of db APIs to be utilized in a J2EE environment and (2) generate stubs for the db API, Java classes and SQL DDL necessary to support the MVC pattern and the Data Own

TransferWare is a collection of tools for the Oracle world: the schema version manager TransVersion (tv), the External Procedure Call (epc) toolkit for accessing the outside world from within Oracle PL/SQL and an application Performance Monitor (pm).

Define your database structure and relations once using the ZsqlML (Zenark's SQL Markup Language) XML DTD, and then generate mulitple vendor-specific SQL scripts, thereby solving the issue of SQL script variances across multiple platforms.

Set of tools and libs for managing structured data in a very flexible way: Imp./Exp. ASCII, XML, SQL, PS, Tex/LaTex, RTF GUI: X-Windows, MS-Windows Interface to C++, DBs, Perl, PHP, Java, TCP/IP LISP-like interpreter written in C++ using C-LIB

Web RAD for PostgreSQL tool.