Postgres or Mysql

I've been using Informix for over a year and I want to migrate to an open source database, either Postgres of Mysql. I mostly build webbased applications and have had a little experience with Mysql in the past, but I heard Postgres is a better choice. Could someone give me some advise. Which one should I chose and why? -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conformance to usenet standards Topic URL: http://www.dbforumz.com/Postgres-Mysql-ftopict279122.html Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=954144

Enver wrote: >I've been using Informix for over a year and I want to migrate to an >open source database, either Postgres of Mysql. I mostly build >webbased applications and have had a little experience with Mysql in >the past, but I heard Postgres is a better choice. > >Could someone give me some advise. Which one should I chose and why? > You should be asking, too, on what platform. In my experience, MySQL is rock solid, dependable and easy to use on both Solaris and Linux (and it usually comes with your Linux distribution). Most other things you'll be tempted to use; e.g., so-called "LAMP" applications will, most likely, run without any headaches whatsoever. If you like weird things like stored procedures and triggers and functions (all to be avoided like the plague unless absolutely needed for something or other), MySQL 5.x supports those. 'Far as I know, none of the above are true with Postgres. Up to you.