Open Source PL/SQL Build Tools for BSD

JDBC Tester is a software that allows to prove JDBC connections and SQL statements. The central idea is to have a software that is used for the design of statements and learning SQL with an graphical user interface simple to use.

LOG4PLSQL is a PLSQL framework for logging in all PLSQL code this project was born from the log4J spirit (and use it). You have the possibility to log apart from transaction and use all LOG4J feature.

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.

DBBinder++ is a data-binder/ORM tool for SQL Databases (SQLite, MySQL, Firebird, Oracle and possibly others). Given an input file which contains severall SQL commands, it will generate source code to easily acess the results.

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.

Jipes provides open source Java APIs deeply integrated into the Oracle RDBMS, including an Ant task for building and exporting database objects. A Java Data Cartridge replacing database links is also in process.

Oracle Database Front-End with database navigation, code editor, syntax highlighting and tab completion for database objects.

Github repository: https://github.com/miguelaxcar/PHP-MSSQL-Server-Admin Web based tool written in PHP by Luiz Miguel Axcar to build and run queries on a remote or local MSSQL (Microsoft SQL Server). Support for SQL code highlight (!), table browser, field browser, TOP records, most used tables, CSV results export, etc. Most tested in SQL 2000 version. If you find some issue ther let me know and I help you fixing it.

PLNet.org is a repository of open source software that is written in PL/SQL or otherwise benefits PL/SQL developers. SourceForge hosts the "meta-project" for the repository tools: management, search, retrieval, update, and others.

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.

phpRPC is meant to be an easy to use xmlRPC library. Function syntax, and plugging into most CMS's (xoops, nuke, pn, etc) is greatly simplified with the use of database/rpc-protocol abstraction. It should run on any php server with most databases.