Re: mysql Compare with postgres? (Re: Advice needed on large database project)

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_at_c-lab.de
                                                     Tel: (+49) 05251-60 6133
 Information is not knowledge is not wisdom          Fax: (+49) 05251-60 6065