Re: Database versus filesystem for storing images

Поиск
Список
Период
Сортировка
От Jorge Godoy
Тема Re: Database versus filesystem for storing images
Дата
Msg-id 871wm9i03e.fsf@gmail.com
обсуждение исходный текст
Ответ на Re: Database versus filesystem for storing images  ("Jeremy Haile" <jhaile@fastmail.fm>)
Ответы Re: Database versus filesystem for storing images  (Andrew Chernow <pg-job@esilo.com>)
Re: Database versus filesystem for storing images  ("Jeremy Haile" <jhaile@fastmail.fm>)
Список pgsql-general
"Jeremy Haile" <jhaile@fastmail.fm> writes:

> Another thing to consider is that storing them in the file system makes
> it much easier to browse the images using third-party tools, update
> them, archive them (by gzipping or whatever).  This is much more
> difficult if they are stored in the database.

If you touch the files with third-party tools how are you going to prevent
that they aren't missing when the database say they are there?  If you're
referencing them somehow, you have to guarantee that they are there...  Or am
I the only one that is thinking about referential integrity with those files?

--
Jorge Godoy      <jgodoy@gmail.com>

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: [ADMIN] vacuum fails with 'invalid page header' message
Следующее
От: John McCawley
Дата:
Сообщение: Re: Database versus filesystem for storing images