This is a discussion on Re: Postgres or Mysql within the Informix forums, part of the Database Server Software category; --> Enver wrote: >I’ve been using Informix for over a year and I want to migrate to an >open source ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |