Re: [cobalt-users] MySQL or PostGreSQL on RAQ3i

[Jan P Tietze <jptietze@xxxxxxxxxxx>]

You're comparing apples and oranges here... MySQL is extremely fast
because it lacks numerous features contained in PostgreSQL, like
transaction processing for instance. This is sometimes a must-have,
sometimes it is not; serving content from MySQL is ok, but generating
order records for a shopping site sometimes isn't, depending on the
integrity you need. MySQL is good if you have to process huge amounts of
SELECTS on large databases, like generating billing information from
telephony logs etc. It does not however provide the functionality needed
in more serious applications, where PostgreSQL is much stronger.

PostgreSQL 7 supports referential integrity checkig, and I would *love*
to see that on the RaQ3. Unfortunately, Cobalt probably won't update
PostgreSQL in the near future as their "special sauce" database (that
btw contains an interestingly low amount of informtion) depends on it.

Andrew Antonietti wrote:

> Apparently Mysql is faster than pg.... so I've read....
>
> We also have it running with php3 .. works extremely well..
> No hiccups yet. ; )
>
> But how do you turn off the pg daemon without the box screaming ?
> (to save a minute amount of resources : ))
> I can stop it from being started at boot..  no probs..

Apart from the GUI probably not working as intended anymore...

Jan