Skip site navigation (1) Skip section navigation (2)

Re: Storing Large Objects

From: brew(at)theMode(dot)com
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: brew(at)theMode(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Storing Large Objects
Date: 2005-04-19 00:44:21
Message-ID: Pine.BSF.4.58.0504182039330.13453@themode.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
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(at)theMode(dot)com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================


In response to

pgsql-novice by date

Next:From: John DeSoiDate: 2005-04-19 02:55:23
Subject: Re: Windows XP PostgreSQL usage
Previous:From: Walker, Jed SDate: 2005-04-18 20:22:28
Subject: Re: Authentication problem

pgsql-performance by date

Next:From: Bruce MomjianDate: 2005-04-19 01:45:15
Subject: Re: How to improve db performance with $7K?
Previous:From: Alvaro HerreraDate: 2005-04-18 22:56:21
Subject: Re: How to improve db performance with $7K?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group