Re: FW: How to store binaries and ASCII files in DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Hi,

On 6/15/05, Weber Matthias <weber@xxxxxxxxxxxxxxxxxxxx> wrote:
> is their any php code example on how to store files (binary and
> ASCII) into a postgres db?

There's not so much difference between a data INSERT and file storage.
But, as a first step, you should decide on the way you want to store
the related data. Will it be stored on a normal table row (in a bytea
field) or as a large object? If you'll use LO, then you should refer
to its documentation for related functions and examples. But if you'll
use a normal bytea column, I'd strongly encourage you to use
parameters while inserting data. This is going to save you from CPU
and RAM wasting escaping routines, plus SQL-Injection attacks. (For
further performance tweaks, you can use binary mode while transmitting
data.)

Regards.


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux