On Thu, Apr 19, 2001 at 12:17:44PM -0500, John Powell wrote:
> > Also why choose mysql over postgres???
>
> The basic, in a nutshell response to the difference is this:
>
> MySQL is simple, and to the point. Most will argue (and I would agree),
> MySQL is faster and less resource intensive.
No, the reason e-smith chose MySQL is that it was required by IMP for
web mail.
> The uses e-smith has for a db basically fall into the range where
> performance is key, the systems are often low-end Pentiums, and integrity is
> not paramount (and the volume is such that it is not likely to be an
> issue). Also, as volume is fairly low, good coding will minimize situations
> where integrity is compromised (multiple processes accessing/updating the
> same data concurrently).
Actually, the only use e-smith has for MySQL in the e-smith server and
gateway distribution is IMP. Now it's there we might use it for other
things, but really it was just a case of:
- we needed web mail
- IMP was the best one we could find
- IMP used MySQL
- We didn't see any point in rewriting IMP to use Postgres
I don't think anyone at e-smith has any real objections to Postgres, and
in fact I know that most of the team here are well aware of its
strengths and many find it superior to MySQL for many uses. It's just
not what IMP used.
Hope that's cleared it up :) Feel free to install Postgres on your
e-smith system, or better yet to package it as an e-smith contrib
module!
K.
--
Kirrily "Skud" Robert -- [EMAIL PROTECTED]
Developer website: http://www.e-smith.org
Corporate website: http://www.e-smith.com
