Free relational software for linux

Firebird is a relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms.

Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. Firebird Relational Database has been used in production systems and under a variety of names since 1981.

Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000 under the InterBase Public License v.1.0.


New code modules added to Firebird are licensed under the Initial Developers Public License. (IDPL). The original modules released by Inprise are licensed under the InterBase Public License v.1.0. Both licences are modified versions of the Mozilla Public License v.1.1.

Installing:

In order to install the firebird version of IB 6.0 you will need to perform the following steps:

1. Get the required packages:

Get the glibc update from RedHat, the one I used
was from ftp://updates.redhat.com/7.0/i386/glibc-2.2-5.i386.rpm

Get ncurses4 from
ftp://carrier.ision.net/pub/ftp.redhat.com/i386/en/RedHat/RPMS/ncurses4-5.0-2.i386.rpm
or another redhat mirror.

Get Firebird from
ftp://firebird.sourceforge.net/pub/firebird/release/FirebirdSS-0.9-1.i386.rpm

2. Prepare the installation:

Log in as root.
Use a plain text console to do this and be sure
that all Gnome desktops are closed.
(One user reported that the Gnome desktop
(apparently ICEwm)
blocked port 3050. I could not reproduce this
here, but it seems that it uses port numbers
that arent assigned in /etc/services for own
purposes)

3. Add localhost.localdomain to /etc/hosts.equiv:
echo localhost.localdomain >>/etc/hosts.equiv

4. Change to the directory where you have placed
the downloaded packages.

5. Install the glibc update:
rpm --install --force glibc-2.2-5.i386.rpm

6. Install libncurses.so.4:
rpm --install --force ncurses4-5.0-2.i386.rpm

7. Install Firebird:
rpm --install --force FirebirdSS-0.9-1.i386.rpm

8. Add /opt/interbase/bin to your path:
You can either change /etc/profile
or do
export PATH=$PATH: /opt/interbase/bin
or
change the profiles in your users home directories

9. Check that all went well:

Read /opt/interbase/SYSDBA.password
to get your SYSDBA password.

gsec -display
should display the list of known users
(SYSDBA only after a fresh install)

isql /opt/interbase/examples/employee.gdb
SQL> SHOW TABLES;
should display all tables from this database
SQL>quit;

WebPython is a Web-application development toolkit written in the Python programming language.
WebPython project contains an object relational database layer, portable over MySQL and PostgreSQL; a document templating engine complete with simple built-in automation; and a mechanism to store Python objects in an SQL database, among other features.
Enhancements:
- This release has database caching through the use of memcached, which greatly speeds up database reads.
- A new version of the Tutorial Blog (using this new feature) has also been released.

KAON project consists of an ontology management infrastructure targeted at business applications.

It includes a comprehensive tool suite allowing easy ontology creation and management and provides a framework for building ontology-based applications.

An important focus of KAON is scalable and efficient reasoning with ontologies.

Persistence mechanisms of KAON are based on relational databases.

Yet Another Calendar is a malleable, clear, concise CGI calendar. Yet Another Calendar project doesnt require a relational database server and uses a single page per month for editing and viewing.
Main features:
- XML/RSS export
- Palm datebook (.pdb) export
- Text export (tab delimited file)
- Single page for editing and viewing
- Optional start and end times for all events
- Edit history/change tracking (with an rcs cron job)
- Archiving of old events (also with a cron job)
- Small amount of source code (under 500 lines)
Enhancements:
- There are now links on the calendar for an XML/RSS feed, a Palm datebook (.pdb) file, and a tab delimited text file.
- A few minor bugfixes and enhancements were made.

GEBORA is an administrative tool for the Oracle Relational Database Management System. GEBORA project is an OpenSource alternative to TOAD.
Since beta-2, GEBORA uses native look-and-feel. This approach looks faster in Windows when huge tables are filled (something about 2000 or more rows).
Main features:
- Send manually created SQL commands to server, showing the results in a table;
- Browse thru all database schemas (users) and its tables and packages;
- Display tables:
- Data (with filter, ordering and printing);
- Columns (can be printed, too);
- Relations (foreign keys) in both directions (referenced tables and tables that references a table);
- Statistics (with unique profile generation and print);
- Creation script (without constraints);
- Display stored procedures source code and parameters;
- Run stored procedures, defining and viewing IN/OUT parameters.

LiteSQL is a C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer.
LiteSQL supports SQLite3, PostgreSQL and MySQL as backends. LiteSQL creates tables, indexes and sequences to database and upgrades schema when needed.
LiteSQL provides object relations, in addition to object persistence which can be used to model any kind of C++ data structures. Objects can be selected, filtered and ordered using template- and class-based API with type checking at compile time.
Main features:
- SQLite3, PostgreSQL and MySQL - backend support
- object persistence layer with relation support
- automatic database schema creation and upgrading
- create complex SQL queries using compile time checked class API; minimizes need to write SQL query strings

Ingres is a mature, high-performance relational database solution.
The project offers scalability, integration and flexibility to leverage information resources across a wide range of platforms, including Linux, Unix, OpenVMS, and Windows.
Reliable and cost effective, it supports mission-critical applications in small to medium-size businesses and high- volume deployments in large scale enterprises.
Enhancements:
- Numerous major enhancements, code speedups, and bugfixes.