Return to BSD News archive
Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!news.telstra.net!psgrain!news.uoregon.edu!tezcat!cam-news-hub1.bbnplanet.com!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!firehose.mindspring.com!hydrant.mindspring.com!cssun.mathcs.emory.edu!news-feed-1.peachnet.edu!paperboy.engeast.baynetworks.com!newsmaster
From: psmith@baynetworks.com (Paul D. Smith)
Newsgroups: comp.infosystems.www.misc,comp.infosystems.www.servers.unix,comp.lang.c,comp.unix.bsd.freebsd.misc,comp.unix.programmer,comp.databases,comp.databases.ms-sqlserver,comp.databases.oracle.server,comp.databases.oracle.misc
Subject: Re: mysql Compare with postgres? (Re: Advice needed on large database project)
Date: 30 Apr 1997 17:12:14 -0400
Organization: Bay Networks, Inc.
Lines: 42
Sender: psmith@lemming
Message-ID: <p5iv1443m9.fsf@baynetworks.com>
References: <5jo09j$20o$1@news.enterprise.net> <33606e0c.3792623@news.sc.edu>
<3360C0C4.31A9264B@id.dk> <5k27n4$3s4$1@gaia.ns.utk.edu>
<336663C4.4B41@ix.netcom.com> <33676770.69ADFAF4@explore.net>
<336773C1.167E@c-lab.de>
Reply-To: psmith@baynetworks.com
NNTP-Posting-Host: lemming.baynetworks.com
X-Newsreader: Gnus v5.3/Emacs 19.34
Xref: euryale.cc.adfa.oz.au comp.infosystems.www.misc:49529 comp.infosystems.www.servers.unix:29433 comp.lang.c:207997 comp.unix.bsd.freebsd.misc:40077 comp.unix.programmer:53790 comp.databases:60587 comp.databases.ms-sqlserver:17860 comp.databases.oracle.server:7730 comp.databases.oracle.misc:6225
%% Thomas Kern <kern@c-lab.de> writes:
tk> There is also mySQL (http://www.tcx.se) which was derived from mSQL.
This is not really correct. The database engine of MySQL was developed
a long time ago, before mSQL appeared, and is completely different.
MySQL is in no way derived from the mSQL source.
However, some of the interfaces such as the perl and C API, and the
interactive client program mysql, were purposefully created to resemble
mSQL (for ease-of-porting, if nothing else). But that's all the
connection they have.
tk> I also have the impression, that [postgres] is the system with the
tk> most ongoing development.
I don't know about that; MySQL has a new beta version out almost weekly,
and the 3.20 release is coming up quite shortly: the MySQL developers
seem chomping at the bit to start 3.21 with some major new features.
Bugs in the beta have been found within hours given appropriate test
cases, and the developers usually post a patch right to the mailing
list, if you're into that kind of thing, rather than making you wait
until the next release.
MySQL also uses threads, while Postgres uses a new process for each
client access (last time I looked). Which one is better is somewhat a
religious issue, but I prefer threads myself.
But you're right, Postgres has the most featurful SQL support. If you
really need full-fledged SQL you should start there.
By all means, check all three out! They're all freely available for
download to try out... although they have different licensing for actual
use.
--
-------------------------------------------------------------------------------
Paul D. Smith <psmith@baynetworks.com> Network Management Development
"Please remain calm...I may be mad, but I am a professional." --Mad Scientist
-------------------------------------------------------------------------------
These are my opinions--Bay Networks takes no responsibility for them.