Re: Storing Binary Large Objects

On Wed, 28 Mar 2007, David E. Wheeler wrote:

> I think I'd use the bytea type for files that are relatively small?say up
> to 256K or something, and maybe smaller. Otherwise I'd use the lo_*
> functions (although they are rather a PITA). How big are these PDFs you
> need to manage?

David,

They're large: 2-7M for most. They're all the operating permits scanned as
pdf files. For one project site I have 42M worth so far.

While paper copies need to be available at the mines and mills, a central
repository for the digital copies is also required for efficient compliance
management.

This need is new to me so I'm open to any and all suggestions on how to
handle these within the database structure. If it's more efficient to store
them in a separate directory on the server and provide pointers within the
database table, then that's the way we'll go.

Thanks,

Rich

--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863