Thanks guyz.
Yep, now I read the FAQ and your replies and I have no doubt that I'll go
with PostgreSQL because I can't even imagine a modern database without
subqueries, foreign keys and tons of other stuff that MySQL doesn't
implement.
"Stuart Robinson" <stuart@zapata.org> wrote in message
news:Pine.LNX.4.30.0111211122120.2565-100000@dreamingameric.com...
> 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