Re: [GENERAL] Blobs in Postgresql

2007-08-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/17/07 23:16, Merlin Moncure wrote: On 8/18/07, Ron Olson [EMAIL PROTECTED] wrote: The language is Java. I've made some tests and they work very well for 25meg filesworks exactly the way it should, first time. MySQL had all kinds of nasty

Re: [GENERAL] Blobs in Postgresql

2007-08-18 Thread Shane Ambler
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/17/07 23:16, Merlin Moncure wrote: On 8/18/07, Ron Olson [EMAIL PROTECTED] wrote: The language is Java. I've made some tests and they work very well for 25meg filesworks exactly the way it should, first time. MySQL had

Re: [GENERAL] Blobs in Postgresql

2007-08-17 Thread Trent Shipley
On Wednesday 2007-08-15 05:52, Gregory Stark wrote: Ron Olson [EMAIL PROTECTED] writes: Hi all- I am evaluating databases for use in a large project that will hold image data as blobs. I know, everybody says to just store pointers to files on the disk... Well not everyone. I usually

Re: [GENERAL] Blobs in Postgresql

2007-08-17 Thread Merlin Moncure
On 8/15/07, Ron Olson [EMAIL PROTECTED] wrote: Hi all- I am evaluating databases for use in a large project that will hold image data as blobs. I know, everybody says to just store pointers to files on the disk...can't do it here...the images are of a confidential nature and access to the

Re: [GENERAL] Blobs in Postgresql

2007-08-17 Thread Ron Olson
The language is Java. I've made some tests and they work very well for 25meg filesworks exactly the way it should, first time. MySQL had all kinds of nasty surprises for me when I first started working with blobs, but I can say that I took my code, changed the driver, and it all works like a

Re: [GENERAL] Blobs in Postgresql

2007-08-17 Thread Merlin Moncure
On 8/18/07, Ron Olson [EMAIL PROTECTED] wrote: The language is Java. I've made some tests and they work very well for 25meg filesworks exactly the way it should, first time. MySQL had all kinds of nasty surprises for me when I first started working with blobs, but I can say that I took my

Re: [GENERAL] Blobs in Postgresql

2007-08-15 Thread Gregory Stark
Ron Olson [EMAIL PROTECTED] writes: Hi all- I am evaluating databases for use in a large project that will hold image data as blobs. I know, everybody says to just store pointers to files on the disk... Well not everyone. I usually do, but if you're not handling these blobs under heavy load

[GENERAL] Blobs in Postgresql

2007-08-14 Thread Ron Olson
Hi all- I am evaluating databases for use in a large project that will hold image data as blobs. I know, everybody says to just store pointers to files on the disk...can't do it here...the images are of a confidential nature and access to the database (and resulting client app) will be highly

Re: [GENERAL] Blobs in Postgresql

2007-08-14 Thread Pavel Stehule
So turning to Postgresql, can I get any recommendations, suggestions and tips on blob handling in the database? The image sizes will be pretty variable, from a few kilobytes to several hundred megabytes, so I need something that will handle the various file sizes, hopefully transparently.

Re: [GENERAL] Blobs in PostgreSQL

2001-06-27 Thread Richard Church
Any examples available, please? On all of creating, insertion, updateing, setting it to null? From: Alex Pilosov [EMAIL PROTECTED] To: Richard Church [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [GENERAL] Blobs in PostgreSQL Date: Wed, 27 Jun 2001 08:43:33 -0400 (EDT) SQL syntax