Oracle Open Source Directory

by Sean Hull, senior consultant at iHeavy, Inc., and coauthor of Oracle and Open Source

Since the release of Oracle and Open Source in May 2001, many new open source projects and technologies relating to Oracle have surfaced. These include tools to do database backups and tuning; technologies for easier database programming and interaction within a wide range or languages; and tools for schema management, application design, and to help DBAs.

I've compiled a database of these Oracle-related open source tools and projects. Take a look below and explore some of the Web sites for these projects.


Command Line Tools
In this category I've included all tools which don't readily have a graphical interface other than from a shell. The only exclusion is servers, or daemons, which also don't have an interface besides the command line, but are included below in the servers page. There are many MySQL-like tools for Oracle, SQL*Plus replacement shells, and much more.

Web-based Clients
Here I've covered a whole group of applications written in various languages from PHP and Python to Perl. They are all Web-based graphical interfaces to Oracle in some way or other. Included are a couple of e-commerce solutions, Web-portals, and Web-publishing solutions, as well as many others.

GUI-based Clients
Here you'll find any other GUI applications. Gnome and KDE applications, as well as C, C++, and Java-based applications are covered here. You'll find object browsers, schema tools, and many other useful applications for your desktop.

Libraries
This category includes libraries that make your database access easier. Included are libraries for C, C++, Python, Perl, PHP, Java, PL/SQL, and ML. These are sure to make your programming easier, so take a look here before embarking on any new open source project.

Languages
There are many languages to choose from when building open source applications. Here we touch on some of the most popular, including C, C++, Java, PHP, Perl, and Python.

Server Software
Server applications, as opposed to client applications, sit on the server-side, offering some sort of Internet or intranet-based service. Included here are an email server and radius server using Oracle as a backend datastore, Apache server extensions, a Linux-based clustering solution with Oracle support, a Linux-based load-balancing solution with Oracle support, and a backup solution.