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@listserv.aoir.org [mailto:air-l-bounces@listserv.aoir.org] On Behalf Of elw@stderr.org Sent: Tuesday, July 25, 2006 12:56 PM To: air-l@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@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/