Re: PG vs MySQL

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(at)zapata(dot)org> wrote in message
news:Pine(dot)LNX(dot)4(dot)30(dot)0111211122120(dot)2565-100000(at)dreamingameric(dot)com(dot)(dot)(dot)
> 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(at)zapata(dot)org]
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html