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 DF6A353B9B for ; Mon, 18 Apr 2005 12:02:38 -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 42277-09 for ; Mon, 18 Apr 2005 15:02:26 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 1E9165372D for ; Mon, 18 Apr 2005 12:01:52 -0300 (ADT) Received: (qmail 22894 invoked by uid 500); 18 Apr 2005 15:21:18 -0000 Date: Mon, 18 Apr 2005 10:21:18 -0500 From: Bruno Wolff III To: brew@theMode.com Cc: pgsql-novice@postgresql.org Subject: Re: Storing Large Objects Message-ID: <20050418152118.GA22606@wolff.to> Mail-Followup-To: Bruno Wolff III , brew@theMode.com, pgsql-novice@postgresql.org References: <70E6659A9338D8418379B4EC0CA5819137928D@erumomw002.eemea.ericsson.se> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/230 X-Sequence-Number: 13113 On Mon, Apr 18, 2005 at 02:09:10 -0400, brew@theMode.com wrote: > > Since I've heard large objects were a bother I've written it so the mp3s > were in files with long obfuscated filenames and have put them in a > directory hidden behind basic authentication, planning a php front end to > the basic authentication and storing the file urls in the database. Now > I'm considering shortlived symbolic filenames to further make it difficult > to rip off the mp3 files by other users with valid log in credentials that > can get past the basic authentication. 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.