Re: mysql proxy - Mailing list pgsql-advocacy

From Andrew Sullivan
Subject Re: mysql proxy
Date
Msg-id 20070827192316.GI30147@phlogiston.dyndns.org
Whole thread Raw
In response to Re: mysql proxy  (Josh Berkus <josh@agliodbs.com>)
Responses Re: mysql proxy  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-advocacy
On Mon, Aug 27, 2007 at 10:40:33AM -0700, Josh Berkus wrote:

> in seeing us add scripting capabilities to it like MySQL has; it
> seems like a cool idea.

Just because you can do something doesn't mean you should.  The idea
of running scripts in between the "real" client and the database that
is ostensibly handling the presumably valuable data makes me airsick.
Anything that you could do in such a script, you could do with a
stored procedure, and you'd get the benefits of ACID along with it.
I have to agree with whoever it was upthread who suggested that this
is a MySQL-ish way of getting access to capabilities PostgreSQL has
had for some time (and, as usual, in a more usual, safer, complete
way).

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
        --George Orwell

pgsql-advocacy by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: The naming question WAS: Theme of this release: Performance?
Next
From: Ron Peterson
Date:
Subject: Re: The naming question WAS: Theme of this release: Performance?