[Air-l] : postgresql and mysql

[Charlie Balch]

I think the "problem" with postgresql is that it is an enterprise level
system. Enterprise level systems require a lot of expertise to install,
maintain, and program. On the other hand they are more stable and efficient.


I found an interesting read at
http://docs.moodle.org/en/Arguments_in_favour_of_PostgreSQL - I'm convinced.
Hopefully I'll not have to write too many different SQL statements.
Charlie

-----Original Message-----
From: air-l-bounces at listserv.aoir.org
[mailto:air-l-bounces at listserv.aoir.org] On Behalf Of elw at stderr.org
Sent: Tuesday, July 25, 2006 12:56 PM
To: air-l at listserv.aoir.org
Subject: Re: [Air-l] : postgresql and mysql

> Charlie Balch:
> I've read good things about postgresql 
> (http://www.postgresql.org/about/). I don't know why postgresql is not 
> more popular. Portability is going to be a major concern when I do my 
> next rewrite. While postgresql runs on many platforms, it does not 
> seem to have the installed base of MySQL.

mysql is 'easy' to pick up, but lacks many of the features that are actually
useful for writing dependable software.  it is very easy to write completely
non-portable, inefficient, sloppy bad software with mysql - and never be
able to move to some other backend without extreme pain.

postgresql is a little further up the learning curve, but there's quite a
bit more power exposed to the programmer/dba.  and you're a lot closer to
"standards-compliant" - which makes your support folks very happy.

--elijah
_______________________________________________
The air-l at listserv.aoir.org mailing list is provided by the Association of
Internet Researchers http://aoir.org Subscribe, change options or
unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org

Join the Association of Internet Researchers: 
http://www.aoir.org/