Oracle and PostgreSQL Debate
Mark Brunelli writes DBAs are talking about the merits of the open source PostgreSQL database management system (DBMS) as compared to Oracle - and their opinions truly run the gamut. DBAs responding to the interview said they liked the low cost and ease of use of the open source database, while others said that Oracle's rich feature cannot be ignored. Still others talked about how well the two systems play together. According to one DBA, a gateway product from Oracle would be a welcome offering."
We're using PostgreSQL as the indi backend; it handles requests both from a Jabber server and a Ruby on Rails web site and web service using the native extension (i.e., written in C) driver.
It's working great so far, and since ejabberd has native integration with PostgreSQL, we'll be able to switch to that pretty easily.
The Army reading list
http://www.whenpenguinsattack.com/2006/02/mysql-vs -postgres.html
b ase-speed-tests.html
and a speed test of various databases
http://www.whenpenguinsattack.com/2006/03/10-data
Of course that's all he has to offer. He's pretty much a spambot to plug the software he's working on. Thank god someone else finally realized that. Now if only the mods could realize it, too.
It's like sex, except I'm having it!