To Blob or Not to Blob? THAT is the question. - Mailing list pgsql-admin

From working4aliving
Subject To Blob or Not to Blob? THAT is the question.
Date
Msg-id OE56k4ruJfE9MswF0Ss000041aa@hotmail.com
Whole thread Raw
List pgsql-admin
I have a java app that (is currently using MYSQL, but we're converting to Postgre soon) references small (62kb) images for viewing on the screens of the app.
 
Does anyone have any thoughts on database design that they can share with me that would validate why I would want to put Images into blobs in the database, as opposed to just using the filesystem?  I haven't seen much info on (philosophically speaking, I guess)  pro's and con's of using blobs vs. the filesystem reference to the images, so I don't have much data to make a decision on if blobs for this purpose are a good idea, other than the fact that I feel IMO that maintenance for them would be much easier in the filesystem.
 
Thanx in advance.
 

pgsql-admin by date:

Previous
From: Andrew Perrin
Date:
Subject: Re: URGENT: undoing a mistake
Next
From: Jodi Kanter
Date:
Subject: array character types