Re: bytea columns and large values

2011/10/2 Merlin Moncure <mmoncure(at)gmail(dot)com>

> On Sat, Oct 1, 2011 at 4:27 AM, Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
> wrote:
> > Hey Merlin,
> >
> >> The lo interface sucks but it's slightly better on resources for
> >> really huge bytea and tends to be more consistently implemented in
> >> database drivers. If I was doing this, I would of course be crafting
> >> a carefully generated client in C, using libpqtypes, which is the gold
> >> standard for sending bytea against which all others should be judged.
> >
> > I am sorry, but why the Large Objects interface sucks?
>
> hm, good question. well, it's not sql and is outside the type system.
> imo, bytea is really the way to go for sending binary. also, if it
> turns out that we need to add features to send large pieces of data,
> it should not be specific to bytea.
>
But at the moment, the only way to put/get the data piecewise
is to use LOBs.

>
> merlin
>
> merlin
>

--
// Dmitriy.