On Fri, 5 Dec 2003, Patrick Rigney wrote:
One of the things that mission-critical-appropriate
databases provide, IMHO,
is a running transaction log or similar mechanism that facilitates not only
transaction management and rollback, but also backup and recovery up to a
point in time. I'm pretty sure MySQL doesn't offer this. Does anyone know
if PostgreSQL does?
MySQL does with InnoDB. PostgreSQL has for a longer period of time;
I've used MySQL for many years now. It's an incredible database. I've yet
to need anything else... perhaps thats a reflection on my hubris in
accepting an RDBMS - but I've released multiple pieces of software that
run on MySQL, and never wanted.
Of course, I'm biased. But until you try it, you never appreciate it.
Perhaps the same could be said for my not trying Oracle... but you know,
that lacking multiple hundreds of thousands of dollars for licences :)
I've never used PostgreSQL either - but I know its an extremely fine
RDBMS, not as fast as My, but has a number of extra features that is
desirable to many developers.
At any rate, for what its worth, my opinion. I've only been using MySQL
for five years now :)
JP