Re: Database versus filesystem for storing images - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Database versus filesystem for storing images
Date
Msg-id 871wm9i03e.fsf@gmail.com
Whole thread Raw
In response to Re: Database versus filesystem for storing images  ("Jeremy Haile" <jhaile@fastmail.fm>)
Responses Re: Database versus filesystem for storing images
Re: Database versus filesystem for storing images
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [ADMIN] vacuum fails with 'invalid page header' message
Next
From: John McCawley
Date:
Subject: Re: Database versus filesystem for storing images