This link has been floating around for some time. I just went to it but it
has been removed temporarily:
http://www.postgresql.org/comp-comparison.html
The one on the MySQL site leaves out quite a lot without explanation. For
instance, it claims that no major RDBMS supports ANSI Triggers. Now, I know
most of them (except MySQL) support triggers, so I have to wonder what the
use of the word ANSI changes.
In any case, use your own judgment:
http://www.mysql.com/information/crash-me.php
Some things you may not learn from this source are:
1) Not ANSI SQL92 compliant (e.g. JOIN syntax among others)
2) Not truly open source or free (read the license) although
the popular myth is that MySQL's licensing is of the same
class as Linux or Apache.
3) No support for triggers and no current plans to implement
support in future releases.
4) No support for stored procedures however this has been on
the MySQL to-do list for awhile
5) No support for foreign keys.
6) No support for views.
6) No support for nested SELECT statements (one of my
personal favorite techniques)
7) And, perhaps most importantly, no support for
transactions.
That said, MySQL is a good solution for a lot of situations. We use it
primarily for high traffic logging purposes. It performs very well in this
capacity because of its speed and the fact that logging does not require the
more advanced SQL statements. This also reduces the load on our primary SQL
Servers for very little cost.
If the platform is a *nix, then PostgeSQL (http://www.pgsql.com/) would
probably be a good option, but I wouldn't fight to get it up and running on
a NT box though some say they have.
Personally, I feel the licensing for Microsoft SQL Server is pretty fair,
especially for those of us using it for Internet applications (i.e. the
Internet Connector). The new licensing scheme, implemented in the 2000
release, promises to be even more so for most of us.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-----Original Message-----
From: Lee Borkman [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 21, 2000 10:54 PM
To: Fusebox
Subject: Re: Want to be robbed blind by M$ ???
Alan,
Do you have any philosophical objections to MySQL? Largely free, lots of
great community-provided tools and support, truly multi-platform.
First Linux, then Apache, now MySQL. What next, PHP? ;-)
Let us know what you decide.
Leeb.
---------------------------------------
"McCollough, Alan" <[EMAIL PROTECTED]> wrote:
Okay, here's the deal, folks. I'm looking for a suggestion on an alternative
to MS SQL 7 / SQL 2K. ...
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar�sts&body�sts/fusebox or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/fusebox or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
