Re: Postgres v MySQL 5.0

On Friday 27 October 2006 14:01, Josh Berkus wrote:
)> Duncan,

> > I didn't expect anybody to do a lot of work, but I did hope that
> > somebody would point me towards some authorative articles on the web.
> > They must exist.
>
> Hmmm ... I'm not sure how an article would be "authorative", in the absence
> of published benchmarks or evaluations by standards bodies, neither of
> which OSS DBs have yet. Anything you got would just be someone's opinion.
>
> > I do appreciate your replies, they made interesting reading. You all
> > clearly believe in your product. However, it is a bit worrying that
> > nobody on the Postgres advocacy mailing list could point me towards any
> > authoratative material advocating Postgres over MySQL.
>
> Let me see if I can dig anything up. Generally we try to avoid the MySQL
> comparison because it's not doing open source in general any good to
> constantly have PostgreSQL and MySQL pitted against each other. We'd
> rather be compared with Oracle and DB2.

Generally I agree with Josh's statements above, but I also keep a few links
around of what other people have written for cases like this:

http://feedlounge.com/blog/2005/11/20/switched-to-postgresql/
http://www.sitepoint.com/article/site-mysql-postgresql-1
http://www.phpbuilder.com/columns/tim20001112.php3
http://www.oreillynet.com/onlamp/blog/2005/01/cd_baby_rewrite_in_postgres_an.html
http://www.leaveitbehind.com/home/2005/03/why_switch.html

And of course the following is usually worth pointing people to as well.
http://sql-info.de/mysql/gotchas.html

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL