Re: Re: Why PostgreSQL is not that popular as MySQL? - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: Why PostgreSQL is not that popular as MySQL?
Date
Msg-id 6899.975964208@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why PostgreSQL is not that popular as MySQL?  (Ronald Cole <ronald@forte-intl.com>)
List pgsql-general
Ronald Cole <ronald@forte-intl.com> writes:
> Postgres, yes.  PostgreSQL, no.  PostgreSQL was a new project with
> Postgres95 as a starting point.  Postgres95 was an attempt to put an
> SQL front-end on Postgres.

Right; original Postgres used a query language called "POSTQUEL",
which was sort of like SQL but not compatible.

> AFAIK, most all of the Postgres code was jettisoned early on for
> performance reasons.  That makes PostgreSQL roughly five years old,
> code-wise.

This I dispute.  A lot of the core functionality has a very traceable
lineage back to original Postgres; even though some details of the code
may have been revised pretty heavily, the algorithms and design
decisions remain.  This has good points and bad points ;-) ... but
it's absolutely not true that Postgres95 threw away the existing code
and started over.  As you said yourself, it was more of a question of
sticking a new frontend (ie, parser) on the existing database engine.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "temporary" table is still there
Next
From: Tom Lane
Date:
Subject: Re: names in WHERE and HAVING