From: | Michael Widenius <monty(at)monty(dot)pp(dot)sci(dot)fi> |
---|---|
To: | Patrick Greenwell <patrick(at)stealthgeeks(dot)net> |
Cc: | Scott Perkins <2scott(at)bellsouth(dot)net>, mcgarry(at)tig(dot)com(dot)au, MySQL mailing list <mysql(at)lists(dot)mysql(dot)com>, postgresql-general <pgsql-general(at)postgresql(dot)org>, "php3(at)lists(dot)php(dot)net" <php3(at)lists(dot)php(dot)net> |
Subject: | Re: PostgreSQL vs Mysql comparison |
Date: | 1999-10-06 10:26:43 |
Message-ID: | 14331.8897.440506.850660@monty.pp.sci.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>>>> "Patrick" == Patrick Greenwell <patrick(at)stealthgeeks(dot)net> writes:
Patrick> On Sat, 2 Oct 1999, Scott Perkins wrote:
>> You make a good point about available admin and other facilities etc.
>>
>> I am interested in some of the forum functionalities that seem to be "off the
>> shelf" with Mysql but I have not done my homework yet with PostgreSQL. There
>> must me some good reasons why PostgreSQL beat out
>> Mysql for product of the year or best database or most popular among
>> NIX/NUX users or something recently.
<cut>
Patrick> Don't forget sub-selects, views, row-level locking, stored procedures,
Patrick> triggers, foreign keys, cascading updates/deletes, and probably a couple
Patrick> other things that escape me at the moment.
Patrick> MySQL is great for what it is: a small, exceedingly fast, easy to
Patrick> administer, stable SQL-server for enviroments where the majority of access
Patrick> consist of text reads (like a lot of web sites).
Patrick is right; MySQL still lacks some 'heavy' features, but he
forgot to mention that PostgreSQL lacks a lot of ANSI SQL and ODBC
features that MySQL supports. MySQL has also some very useful (even
if they are nonstandard) features like LOAD DATA INFILE, REPLACE ,
CREATE TABLE from a SELECT, in memory tables...) that postgreSQL
doesn't support.
You can find a comparison that should include all major points at:
http://www.mysql.com/crash-me-choose.htmy
Regards,
Monty
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Widenius | 1999-10-06 10:43:07 | Re: [PHP3] Re: PostgreSQL vs Mysql comparison |
Previous Message | Mike Mascari | 1999-10-06 07:23:37 | Re: [GENERAL] You are really hosed. |