Re: PG vs MySQL

and never forget foreign keys :)

They make life so easy.
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------

----- Original Message -----
From: "Stuart Robinson" <stuart@zapata.org>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, November 21, 2001 9:26 PM
Subject: Re: [GENERAL] PG vs MySQL


> For what it's worth, I'm one of those people who switched from mySQL to
> PostgreSQL. Why?  Because the latter has a number of capabilities that the
> former is lacking, chief among these being:
>
> 1. transactions
> 2. views
> 3. subqueries
>
> Andrey Shcherbina wrote:
>
> > > Hi,
> > >
> > > I'm sure this question was asked before but I can't find the answer.
> > >
> > > I've just started looking at options of runnnig Linux-based (actually,
I
> > > need something free :) database engines with MS Access as a front-end.
I
> > > can't find any comparison between PostgreSQL and MySQL. It seems so
far
> > > that PG is better (people tend to migrate to PG, not vice versa) and
> > > that's why I'm asking this question on PG newsgroup but not on MySQL.
> > > Anyway, it would be really nice to have that information on what
exactly
> > > is different in the engines.
> > >
> > > Thank you,
> > > Andrey Shcherbina
>
> --
> Stuart Robinson  [stuart@zapata.org]
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>