X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 065C05359F for ; Mon, 18 Apr 2005 21:44:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59203-03 for ; Tue, 19 Apr 2005 00:44:19 +0000 (GMT) Received: from themode.com (themode.com [161.58.169.198]) by svr1.postgresql.org (Postfix) with ESMTP id 522BF534D4 for ; Mon, 18 Apr 2005 21:44:18 -0300 (ADT) Received: from localhost (bde@localhost) by themode.com (8.12.11/8.12.11) with ESMTP id j3J0iLVa015045; Mon, 18 Apr 2005 20:44:21 -0400 (EDT) Date: Mon, 18 Apr 2005 20:44:21 -0400 (EDT) From: brew@theMode.com X-X-Sender: mode@themode.com To: Bruno Wolff III Cc: brew@theMode.com, pgsql-novice@postgresql.org Subject: Re: Storing Large Objects In-Reply-To: <20050418152118.GA22606@wolff.to> Message-ID: References: <70E6659A9338D8418379B4EC0CA5819137928D@erumomw002.eemea.ericsson.se> <20050418152118.GA22606@wolff.to> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200504/241 X-Sequence-Number: 13124 Bruno.... > Why not put the files somewhere where only the application can get at > them instead of under the document root. That way they have to > compromise your application to get at them. No amount of url guessing > will give direct access. Great idea. That's what I will do, no need to complicate my life (and server) by storing the files as large objects in the database. It looks like php's readfile function will do the job nicely. Thanks Bruno! brew ========================================================================== Strange Brew (brew@theMode.com) Check out my Stock Option Covered Call website http://www.callpix.com and my Musician's Online Database Exchange http://www.TheMode.com ==========================================================================