Re: Dreaming About Redesigning SQL

From: lauri(dot)pietarinen(at)atbusiness(dot)com (Lauri Pietarinen)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dreaming About Redesigning SQL
Date: 2003-10-05 19:47:44
Message-ID: e9d83568.0310051147.48e9789c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Browne <cbbrowne(at)acm(dot)org> wrote in message news:<m3lls1vzfc(dot)fsf(at)wolfe(dot)cbbrowne(dot)com>...

> I think an implementor would be better off using an SQL database
> underneath, and using their code layer in between to accomplish the
> "divorce" from the aspects of SQL that they disapprove of.

That is, in fact, the approach taken in a product called Dataphor
(see www.alphora.com). They have implemented a "D"-language (called D4)
that translates into SQL and hence uses underlying SQLServer, Oracle
or DB2- DBMS'es as the engine.

It is, however, not a very easy mapping to do and you have to resort
to all sorts of unclean stuff to make it work...

regards,
Lauri Pietarinen

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2003-10-05 20:31:33 Re: Thoughts on maintaining 7.3
Previous Message Bruce Momjian 2003-10-05 19:41:15 Re: PQfnumber and quoted identifiers