Re: BLOBs etc - Mailing list pgsql-jdbc

From Thomas Hallgren
Subject Re: BLOBs etc
Date
Msg-id thhal-0ZvW7Av0Mci4dTNfFB38xBcloEoK5nv@mailblocks.com
Whole thread Raw
In response to Re: BLOBs etc  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Oliver Jowett wrote:
> Is doing this transformation work really worth it? If you're going to do
> non-trivial server changes, aren't you better off improving bytea to
> solve the problems it has with large binary data and using bytea
> everywhere?
>
Probably. My LOB change suggestion was more based on keeping things
simple and not change the server much. As you point out, merging that
with a more significant protocol change will impose more changes anyhow
so why not go the full route and get rid of LOB's as the stand today
altogether.

In any case, a good start would be to allow stream access to a bytea on
the server side so that the client can use Blob access and binary streams.

A related topic is of course text and Clob's. It would be nice if the
could be handled the same way with the addition of needed encoding support.

Regards,
Thomas Hallgren




pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: BLOBs etc
Next
From: Sven Köhler
Date:
Subject: Re: BLOBs etc