Re: DBMS Engines and Performance

On Tue, 30 Jan 2007, Mark Walker wrote:

> Does the developer offer any hard evidence for his statement? I mean like
> benchmark tests and a side by side list of features?

Mark,

No. And I've read this excuse from them before when I asked about a port.
The application is written in php and they use adobp (or something like
that) which is supposed to be backend-agnostic, but apparently still favors
MySQL over PostgreSQL. No one in that glue project seems interested in
fixing what's not working, either.

> My impression is that Mysql is set up very narrowly for a typical ISP
> offering LAMP and not much else. Once you start going into corporate
> installations on private servers, you run into problems with Mysql. Some
> of the problems I've have personally are lack of anything that comes close
> to pgadmin and really arcane setup/maintenance.

I remember the days when LAMP stood for Linux, Apache, Middleware, and
PostgreSQL. :-) It's been co-opted, I guess.

At last year's at O'Reilly's OSCON here in Portland I had this discussion
with the booth babes sales droids from Sugar-CRM. They said that they heard
numerous requests for postgres support but the decision-makers in the
company were not interested in accommodating that segment of the market. So
this is not an isolated instance.

At the risk of going off the topic (but I won't respond on the list to any
such posts), this attitude does not surprise me. It continues to disappoint
me, but I've seen too many poorly managed companies to be surprised any
longer. Across many industries I wonder why some companies manage to have
survived as long as they have.

Rich

--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863