Forum OpenACS Q&A: Re: Postgres vs. Oracle for OpenACS

Posted by Janine Ohmer on
This may not be a popular point of view, but my recommendation to clients is still to go with Oracle if they can afford it, and Postgres if they can't or if Open Source is important to them. I have several reasons for this:
  • There are more 3rd party tools available for Oracle than for Postgres (though PG is slowly catching up)
  • There is more reference material out there for Oracle to help when things go wrong
  • I've had decent luck getting help from Metalink and Ask Tom, but not so much getting help from the PG mailing lists
  • Although Oracle's tech support is rumored to be pretty bad, at least it exists
Ok, so my reasons are centered around things going wrong, and perhaps that is more likely to happen with Oracle than Postgres. But as someone who is responsible for a lot of other people's data, having resources to turn to is important to me.