Re: PG vs MySQL - Mailing list pgsql-general

From Stuart Robinson
Subject Re: PG vs MySQL
Date
Msg-id Pine.LNX.4.30.0111211122120.2565-100000@dreamingameric.com
Whole thread Raw
In response to Re: PG vs MySQL  (J Smith <dark_panda@hushmail.com>)
Responses Re: PG vs MySQL
List pgsql-general
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]


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [PATCHES] Version checking when loading psql
Next
From: Tom Lane
Date:
Subject: Re: Default conversion of type numeric to text in 7.1.3