Re: Is SQL silly as an RDBMS<->app interface?

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Antonios Christofides <A(dot)Christofides(at)itia(dot)ntua(dot)gr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is SQL silly as an RDBMS<->app interface?
Date: 2003-07-13 11:38:41
Message-ID: 3F1144C1.3090701@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Antonios Christofides wrote:
> [...]
> suitable for computers. The most obvious example is that integers are
> converted to decimal by the application only to be converted back to
> binary by the RDBMS.

Very good example, indeed. How does the 64bit big-endian DB server use
your frontend's little-endian 32bit integer value? Not to speak of the
binary representation of your expression tree.

You have to do some conversion. By convention this is done by converting
into and from a communication protocol that is possibly different from
the internal representation on at least one side.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba 2003-07-13 12:02:15 drop function all - ?
Previous Message Martijn van Oosterhout 2003-07-13 11:11:37 Re: Is SQL silly as an RDBMS<->app interface?