On Wed, 21 Nov 2001, Stuart Robinson wrote:
> 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
same here. plus UNION (yes i know you could do this in MySQL with separate
selects into a temporary table) and foreign keys.
a while back i was looking to port all of our stuff to pgsql when I
couldn't get MySQL to run stable on my NetBSD/Alpha machine cause of
threading issues. But I got that resolved with MySQL (used to crash a lot
but haven't for months). Then there was that limitation of the 8K issue
that's long resolved with pgsql. And I had to wait for emulated soft
floats to work on NetBSD/Alpha (thanks to Ross Harvey from NetBSD).
as Minnesota.com expands, I'm starting to see limitations of MySQL, very
smiliar to what Tim Purdue stated in his article. All the things I didn't
need before (transactions, views, subqueries, triggers, UNION), I find I
now need. In my process or portign and making my PHP apps for DB
independent, I found myself making lots of special IF/ELSE cases for MySQL
because it's not as standard (case in point, '||' in MySQL is the OR
operator, where it should be concat).
I'd still recommend MySQL for applications that are small and don't forsee
it growing very large, because their interface and setup is much easier to
understand for a beginner.
> > 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
>