MySQL has become the default for most everything that requires a
database (and some things that don't). In my experience, its been
extremely stable, fast, and versatile. The support for it is great,
and thats where it trumps Postgres. Postgres is a strong database in
itself, extremely fast for multiple joins, sometimes faster than
MySQL, and stable. Its not as readily expandable to multiple hosts,
as MySQL is, and its major drawback is in community support. As of
the last version, the PhP scripts for it were horrible. A colleague
of mine was writing some fairly complicated inserts, and the existing
PhP scripts could not handle it, so he was forced to write his own.
Basically, you can look at it in several basic ways:
Which one has a larger user base?
- MySQL by far
Which one has more features?
- Tie
Which one is more scalable?
- MySQL
If I need professional level support, can I get it?
- MySQL definately
- Postgres maybe, but not likely
Which one is more stable?
- The databases themselves are both equally as stable, but the
plugins are more stable in MySQL (PhP example).
Which one has a large community support?
- MySQL by far
Which one can work with multi platform applications (PhP, C, C++,
C#, .NET, ASP, AJAX)?
- MySQL supports all of those, and I have used it successfully with
C# and ASP.NET
Overall both are great database applications, but MySQL has a broader
feature set and more community support, making it the choice for most
organizations.
- Donald Tripp
[EMAIL PROTECTED]
----------------------------------------------
HPC Systems Administrator
High Performance Computing Center
University of Hawai'i at Hilo
200 W. Kawili Street
Hilo, Hawaii 96720
http://www.hpc.uhh.hawaii.edu
On Mar 28, 2007, at 5:16 AM, Michael Hannon wrote:
Hi, folks. If you have any words of wisdom about the relative
merits of PostgreSQL and MySQL, would you please send them to
me?
It would be ideal to hear opinions/experiences, etc., that
relate to the CURRENT versions of these products, but
ancient prejudices, gossip, etc., are all OK.
Please reply directly to me, not to the list.
Thanks.
- Mike
--
Michael Hannon mailto:[EMAIL PROTECTED]
Dept. of Physics 530.752.4966
University of California 530.752.4717 FAX
Davis, CA 95616-8677
