Here's the answer....It depends.
From what I hear, MySQL is faster than PostgreSQL when returning rows, so if
you are building this for a web site and want a REALLY basic backend
database...well then go with MySQL.
But, PostgreSQL is more of a real database as it supports more SQL standards
(like what Stuart said below).
I guess I would hold PostgreSQL up there with other Midrange databases as
Oracle and Sybase.
For my personal choice, I use MySQL for really small sites that don't really
need the database that much and for everything else I use PostgreSQL; once
again because of it's support for SQL.
Thanks, I hope this helps.
Troy Campano
-----Original Message-----
From: Stuart Robinson [mailto:stuart@zapata.org]
Sent: Wednesday, November 21, 2001 2:26 PM
To: pgsql-general@postgresql.org
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