PostgreSQL 7.4 in Detail

Here's a detailed examination of what's what with the other big name open source database: PostgreSQL 7.4.

The "most advanced open source database" just got more advanced. More than a year in the making, the latest release of PostgreSQL is the work of an entirely decentralized, global, and staunchly independent community that values innovation, pragmatism, and novelty as equals. PostgreSQL 7.4 has a host of performance improvements and a panoply of new database programming features for databases of all sizes. The new PostgreSQL is extensible, flexible, and clever. If you thought MySQL was the only game in town, think again.

Since the POSTGRES project was incepted in 1986 by Michael Stonebrakers University of California at Berkeley team, PostgreSQLs developers have emphasized both implementing the most recent ideas on relational database design and standards and enabling users to perform complex tasks inside the database. Many call PostgreSQL the "database administrators database," because it maximizes the use of SQL, data integrity controls, database procedures, and relational theory to do work inside PostgreSQL instead of in middleware code.

PostgreSQLs architecture and Object-Relational features make modular extensions of the database functionality easy and accessible, much like Linux and Apache. And like those other open source projects, PostgreSQL has attracted some unique features to solve unique problems.

For the rest of the story, clock to Linux Magazine.