Re: PDF files: to store in database or not - Mailing list pgsql-general

From John R Pierce
Subject Re: PDF files: to store in database or not
Date
Msg-id 0e7e2842-3544-e86d-75bf-d20952a13035@hogranch.com
Whole thread Raw
In response to Re: PDF files: to store in database or not  (David Wall <d.wall@computer.org>)
List pgsql-general
On 12/6/2016 1:02 PM, David Wall wrote:
> You can certainly put the files in a filesystem and point to them, but
> you'll likely need some access control or people will be able to
> download any/all PDFs in a given folder. In the DB, you surely will
> have access control as I presume you don't allow browser access to the
> DB <smile>.

thats easily remedied by using storage accessed via https or whatever
with directory listing disabled, and hashed names.   Or, only allow your
app server direct access to the file system if its via NFS or whatever.



> Either way, you may want to see if your PDFs compress well or not as
> that may save some storage space at the cost of compress/decompress on
> accesses.


pretty sure most all PDF's are already compressed, and won't compress
much further.

--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Joseph Brenner
Date:
Subject: Re: Select works only when connected from login postgres
Next
From: DrakoRod
Date:
Subject: FATAL: semctl(999999, 6, SETVAL, 0) failed: Invalid argument