Re: Is SQL silly as an RDBMS<->app interface? - Mailing list pgsql-general

From Jan Wieck
Subject Re: Is SQL silly as an RDBMS<->app interface?
Date
Msg-id 3F1144C1.3090701@Yahoo.com
Whole thread Raw
In response to Is SQL silly as an RDBMS<->app interface?  (Antonios Christofides <A.Christofides@itia.ntua.gr>)
List 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@Yahoo.com #


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Is SQL silly as an RDBMS<->app interface?
Next
From: Együd Csaba
Date:
Subject: drop function all - ?