*BSD News Article 94843


Return to BSD News archive

Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!news.telstra.net!act.news.telstra.net!news-out.internetmci.com!newsfeed.internetmci.com!news.stealth.net!news.maxwell.syr.edu!news.apfel.de!fu-berlin.de!news.uni-paderborn.de!not-for-mail
From: Thomas Kern <kern@c-lab.de>
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: Wed, 30 Apr 1997 18:30:57 +0200
Organization: C-LAB
Lines: 37
Message-ID: <336773C1.167E@c-lab.de>
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>
NNTP-Posting-Host: smart.c-lab.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 3.01Gold (X11; I; IRIX 5.3 IP22)
To: Peter Bartnik <pbartnik@explore.net>
Xref: euryale.cc.adfa.oz.au comp.infosystems.www.misc:49528 comp.infosystems.www.servers.unix:29432 comp.lang.c:207996 comp.unix.bsd.freebsd.misc:40076 comp.unix.programmer:53789 comp.databases:60586 comp.databases.ms-sqlserver:17859 comp.databases.oracle.server:7729 comp.databases.oracle.misc:6224

Peter Bartnik wrote:
> 
> Mike,
> 
> >>
> Has anybody used both mysql and postgres and can give some comparison
> between these two?
> <<
> 
> You mean mSQL?

There is also mySQL (http://www.tcx.se) which was derived from mSQL.
It's improved, extended and freely available.

I had a (short) look at postgres95, mSQL and mySQL. Postgres95 is the one with 
the best features (i.p. explicit transactions) and the best SQL support.
I also have the impression, that it is the system with the most ongoing
development. 

mySQL has reasonable features, it's fast and has JDBC support. No commit/rollback, 
though. mySQL is what I'm currently using. However, if I had found a JDBC
driver for postgres, it would have been the system of choice.

mSQL was to limited for me, but there is also JDBC support.

Installation of all three was no problem on Solaris.

  Thomas

-- 
______________________________________________________________________________
  ________                         __ __             SNI/C-LAB
 /_  __/ /  ___  __ _  ___ ____   / //_/__ _______   Fuerstenallee 11 
  / / / _ \/ _ \/  ' \/ _ `(_-<  / ,< / -_) __/ _ \  33102 Paderborn, Germany
 /_/ /_//_/\___/_/_/_/\_,_/___/ /_/|_|\__/_/ /_//_/  kern@c-lab.de
                                                     Tel: (+49) 05251-60 6133
 Information is not knowledge is not wisdom          Fax: (+49) 05251-60 6065