[sub] [Sussex] MYSQL vs Postgresql

[Geoffrey Teale]

Tony,

Hostorically MySQL was faster and thus more popular, however recent
versions of postgreSQL have had better performance than MySQL.

Moreover postgreSQL is a far more "complete" database than MySQL,
although many of the things that MySQL didn't do historically it does do
now.

I have no idea if postgreSQL runs on Windows.

In 99 out of 100 cases I would suggest that PostgreSQL would be a better
choice for new projects. 

-- 
Geoff Teale
 

On Thu, 2004-07-15 at 15:10, Tony Austin wrote:
> Does anyone have any knowledge of why MySQL might be a better or worse
> choice than Postgresql?
> 
> As far as as I can tell:-
> 
> 1. MySQL server can run under Windows as well as Linux but Postgresql will
> not run on Windows.
> 2. The MySQL licence requires payment for commercial applications which
> are not 100% GPL (plus a few exceptions) but Postgresql doesn't.
> 3. I thought that the Postgresql documentation looked a lot easier to get
> started with than MySQL and (to prove it) very quickly had a database up
> and running without knowing very much about anything.  (Not that I am
> saying that there is anything wrong with MySQL online documentation.)
> 
> I have no idea on the relative technical merits of each and presume that
> my humble needs would be covered by both.
> 
> Anyone any thoughts?
> 
> Tony
> 
> Regards.
> 
> Tony Austin
> Gigaday Computing Limited
> http://www.gigaday.com
> tony at gigaday.com
> 
> 
> 
> 
> _______________________________________________
> Sussex mailing list
> Sussex at mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/sussex
>