Re: DBMS Engines and Performance - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: DBMS Engines and Performance
Date
Msg-id 20070202170926.GC11505@phlogiston.dyndns.org
Whole thread Raw
In response to DBMS Engines and Performance  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Tue, Jan 30, 2007 at 11:36:52AM -0800, Rich Shepard wrote:
>   However, what puzzles me is this statement: "PostgreSQL has continued to
> fall behind other database engines in both performance and features, so I
> don't see compelling reason to work on it in my very limited free time."

While the claim is utter bosh, what is probably true is that an
application that has been designed exclusively to work well with
MySQL will just not work very well with Postgres.  That's my
experience, in any case.

Generally, when you get an application that was designed exclusively
to work with MySQL, they're using all the furry little bits in MySQL
that aren't really very SQL-like.  Then, the port is commenced, and
the developers discover that many of the MySQL tricks aren't really
SQL at all, and that they have a bunch of new syntax to learn.
Instead of regarding this as a failing of MySQL to implement
consistently the standard SQL, such developers often regard their
discovery of proof that only MySQL is a good product, that everything
else is garbage, and that all those other systems should just be
ignored.

The alternative approach is that the developers try to come up with
Yet Another Abstraction Layer, so that they can leave the code in
their system that is there to deal with the huge numbers of
historically missing features in MySQL.  Even as MySQL has added some
of those features, the application designers haven't caught up.

The above is not universally true, but I have seen or read such
sentiments often enough to realise that there are plenty of
application developers who don't know anything about their database
technology.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
        --H.W. Fowler

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Predicted lifespan of different PostgreSQL branches
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Predicted lifespan of different PostgreSQL branches