FW: How to store binaries and ASCII files in DB
FW: How to store binaries and ASCII files in DB
От:
"Weber Matthias" <weber@faps.uni-erlangen.de>
Дата:
Hi, is their any php code example on how to store files (binary and ASCII) into a postgres db? Thanks, Matthias
Re: FW: How to store binaries and ASCII files in DB
От:
Pawel Bernat <asm@vlo.olsztyn.pl>
Дата:
On Wed, Jun 15, 2005 at 12:42:28PM +0200, Weber Matthias wrote: > is their any php code example on how to store files (binary and ASCII) into a postgres db? http://www.php.net/manual/en/function.file-get-contents.php http://www.php.net/manual/en/function.pg-escape-bytea.php http://www.php.net/manual/en/function.pg-escape-string.php http://www.php.net/manual/en/function.pg-query.php p. -- Paweł Bernat; uselessness' lover; select''as email; Slowly and surely the unix crept up on the Nintendo user ...
Re: FW: How to store binaries and ASCII files in DB
От:
Volkan YAZICI <volkan.yazici@gmail.com>
Дата:
Hi, On 6/15/05, Weber Matthias 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.