Received: from ngate.rdw.ru ([195.42.172.254]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAT83Gt21888 for ; Wed, 29 Nov 2000 03:03:19 -0500 (EST) (envelope-from borz_off@rdw.ru) Received: (qmail 3786 invoked from network); 29 Nov 2000 08:03:09 -0000 Received: from unknown (HELO SPIDER) (192.168.0.212) by ngate1.rdw.ru with SMTP; 29 Nov 2000 08:03:09 -0000 Date: Wed, 29 Nov 2000 11:03:19 +0300 From: Alexey Borzov X-Mailer: The Bat! (v1.47 Halloween Edition) UNREG / CD5BF9353B3B7091 Reply-To: Alexey Borzov Organization: RDW X-Priority: 3 (Normal) Message-ID: <101701354.20001129110319@rdw.ru> To: chriswood@wvda.com CC: pgsql-php@postgresql.org Subject: Re: Question re large objects In-reply-To: <3A23B26E.9056.2942B3@localhost> References: <3A23B26E.9056.2942B3@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/34 X-Sequence-Number: 42 Greetings, chriswood! At 28.11.2000, 11:00, you wrote: cwc> I'm working on a web page template system (PHP/PostgreSQL) cwc> which will (in part, other stuff is done) allow users to upload a gif or cwc> jpeg via a form on another site. The image will then slot into a cwc> predetermined place on their template website. cwc> I've considered the alternatives (store files in a directory or in the cwc> db), and I think storing the image files in the database is the way to cwc> go. Unless anybody can think of why I should just upload the files cwc> to a directory on the server instead of storing them as BLOBs. Well, there is one (huge) reason - speed. Besides, current BLOB support in pgsql is not too good: 1) You can't pg_dump BLOBs, 2) For _each_ BLOB _two_ files are created in database dir. So, my advice would be to store images in filesystem and to store paths to them in DB. -- Yours, Alexey V. Borzov, Webmaster of RDW