PDF files: to store in database or not

Поиск
Список
Период
Сортировка
Искать
От
Rich Shepard
Тема
PDF files: to store in database or not
Дата
Msg-id
alpine.LNX.2.11.1612061019360.31587@localhost
Список
Дерево обсуждения
PDF files: to store in database or not Rich Shepard <rshepard@appl-ecosys.com>
Re: PDF files: to store in database or not "Joshua D. Drake" <jd@commandprompt.com>
Re: PDF files: to store in database or not Eric Schwarzenbach <subscriber@blackbrook.org>
Re: PDF files: to store in database or not "Joshua D. Drake" <jd@commandprompt.com>
Re: PDF files: to store in database or not Eric Schwarzenbach <subscriber@blackbrook.org>
Re: PDF files: to store in database or not David Wall <d.wall@computer.org>
Re: PDF files: to store in database or not "Joshua D. Drake" <jd@commandprompt.com>
Re: PDF files: to store in database or not John R Pierce <pierce@hogranch.com>
Re: PDF files: to store in database or not Rich Shepard <rshepard@appl-ecosys.com>
Re: PDF files: to store in database or not John R Pierce <pierce@hogranch.com>
Re: PDF files: to store in database or not Tom Lane <tgl@sss.pgh.pa.us>
Re: PDF files: to store in database or not David Wall <d.wall@computer.org>
Re: PDF files: to store in database or not John R Pierce <pierce@hogranch.com>
Re: PDF files: to store in database or not Rich Shepard <rshepard@appl-ecosys.com>
Re: PDF files: to store in database or not Rich Shepard <rshepard@appl-ecosys.com>
Re: PDF files: to store in database or not Moreno Andreo <moreno.andreo@evolu-s.it>
Re: PDF files: to store in database or not "Joshua D. Drake" <jd@commandprompt.com>
Re: PDF files: to store in database or not "Joshua D. Drake" <jd@commandprompt.com>
Re: PDF files: to store in database or not Eric Schwarzenbach <subscriber@blackbrook.org>
Re: PDF files: to store in database or not John DeSoi <desoi@pgedit.com>
Re: PDF files: to store in database or not Rich Shepard <rshepard@appl-ecosys.com>
Re: PDF files: to store in database or not Adrian Klaver <adrian.klaver@aklaver.com>
Re: PDF files: to store in database or not Rich Shepard <rshepard@appl-ecosys.com>
Re: PDF files: to store in database or not Chris Travers <chris.travers@gmail.com>
Re: PDF files: to store in database or not John DeSoi <desoi@pgedit.com>
Re: PDF files: to store in database or not Rich Shepard <rshepard@appl-ecosys.com>
   With no experience of storing binary data in a bytea column I don't know
when its use is appropriate. I suspect that for an application I'm
developing it would be better to store row-related documents outside the
database, and want to learn if that is the appropriate approach.

   Consider an application that manages a fleet of vehicles. There's a
Vehicles table with information on each one (perhaps make, model, VIN, year
of purchase) and a Services table. There are many PDF documents associated
with each row in the tables: purchase contract, insurance form, service and
maintenance records, etc.

   My thinking is to not store these documents in the database, but to store
them in subdirectories outside the database.

   Your thoughts?

Rich


В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Joshua D. Drake
Дата:
FAQ