Обсуждение: Re: Streaming binary data into db, difference between Blob

> I was following the conversation on blobs with interest.
>
> c-jdbc supports Blobs and Binaries with Postgres.
> At the moment though, given the number of different platforms we are
> trying to support there is no streaming as such available.
>

Well, my Blobs aren't that large and if using c-jdbc comes with this
price, I'll have to live with it. It's just that I want to keep this
low memory footprint as long as possible.

I need Blobs in a Java Servlet application and as long as 1 user
uploads/downloads a 5MB blob I don't care. However if 50 people
upload/download 5MB blobs at the same time, buffers will grow to
250MB only for passing data from the db through to the client.
From a theoretical point of view that's ridiculous.

I don't expect this to happen, though. In case I get
OutOfMemoryExceptions I will simply turn off c-jdbc again.

Anyway, both Postgres and c-jdbc are great :-)

Thanks!