SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 09:52 AM
| ||||
| ||||
 Re: Postgres or Mysql > >Ive 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? Your asking this on an Informix list? > 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. Bo-o-o-o-o-gus! If you've worked with Informix then go with PostgreSQL as it will provide most of the features you've come to expect. Even MySQL 5.x only provides extremely rudimentary support for things like triggers, SPL, constraints, etc... But even better - use Informix. We are both a PostgreSQL and Informix shop (our groupware system used PostgreSQL). PostgreSQL is a very nice database and extremely stable, but neither of these can compare with the performance or *TOOLSET* of Informix. Their backup utilities are *S*A*D* compared to the options provided by Informix, and there isn't even an equivalent to "onstat". Come on, you can get Informix for LINUX very cheap - and it is easily worth every penny. [demime 1.01d removed an attachment of type application/pgp-signature which had a name of signature.asc] sending to informix-list      |
Linear Mode
