Re: PDF files: to store in database or not

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: PDF files: to store in database or not
Дата
Msg-id 0e7e2842-3544-e86d-75bf-d20952a13035@hogranch.com
обсуждение исходный текст
Ответ на Re: PDF files: to store in database or not  (David Wall <d.wall@computer.org>)
Список 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 по дате отправления:

Предыдущее
От: Joseph Brenner
Дата:
Сообщение: Re: Select works only when connected from login postgres
Следующее
От: DrakoRod
Дата:
Сообщение: FATAL: semctl(999999, 6, SETVAL, 0) failed: Invalid argument