Re: Streaming blob to db

On Fri, 1 Jul 2005, [UTF-8] �^Y^B�^\^_ 精�^\� wrote:
>
> I got a web application that use jdbc and that will need to stream
> binary data to the database.
>
> My application need an outputstream to send the data to the db, and
> an inputstream to read the data from the db.
>
> I use postgresql 8.0.1 with bytea field.
>
>  >100mb 20%
>

If you are really dealing with 100+Mb files you should probably look into
using large objects instead of bytea storage.  This will provide the
streaming interfaces you are looking for and avoid excessive memory usage.

http://jdbc.postgresql.org/documentation/80/binary-data.html

Kris Jurka