Re: BLOBS in DB and MDB
| From: | Marko Kaening | Date: | Thu, 20 Mar 2003 10:32:04 +0000 |
| Subject: | Re: BLOBS in DB and MDB | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-4324@lists.php.net to get a copy of this message | ||
Hi Jeroen,
> How do people store their binary data (pdf's, word docs etc) in
> Postgres? I noticed you can store it in a TEXT field (up to 1GB IIRC),
> but also using OID's. Which techniques do MDN/DB use?
as far as I know it is recommended never to store binary data like this
directly in a database, instead rather store there location in a file
system. This speeds everything up dramatically and is safer, assuming the
file system is held consistent with the DB.
Marko