mysql vs. postgresql

Carl Parrish plug-discuss@lists.plug.phoenix.az.us
13 Jun 2003 10:24:54 -0700


There was a time when I would say. MySQL for speed PostgreSQL for
transactions, stored procedures etc.... Today with just a little
fiddling you can get PostgreSQL to run almost as fast as mysql and by
changing the tables of mySQL you can get it to be almost as "standard"
as PostgreSQL. That said if you want to put a Mozilla interface on an
application right now it's *much* easier to use PostgreSQL. I still tend
to use mySQL for php apps but that's mostly just because its what I'm
used to. 

Carl P. 

On Fri, 2003-06-13 at 10:56, Mike Starke wrote:
> Mighty tempting subject line for some of you, but
> here is where I am at:
> 
> I am looking for some "recent" unbiased comparisons
> for the two db servers. I have been tempted to port
> over to postgresql after years of faithful service
> w/mysql, but have yet to find a reason.  
> 
> I have read many articles, but none appear to be up-to-date.
> They all complain about mysql not having this and that. That
> was 2 versions ago.
> 
> Again, intelligent recent unbiased comparisons is what I am looking for.
> I also want to keep in mind the average installation is not
> handling the transactions one see's down there at NASDAQ:
> I am thinking of a db server for a small company (50-250 people),
> business apps (GNUe) and web work (apache/perl|php).
> 
> v/r
> -mike
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change  you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
-- 
Carl Parrish (cparrish@carlparrish.com)
http://www.carlparrish.com
---
Registered Linux User #295761 http://counter.li.org