Re: To Blob or Not to Blob? THAT is the question.

["Josh Goldberg" <josh(at)4dmatrix(dot)com>]

I'm using blobs for ease of management in a high volume, distribuited content distribution system.  My last version of the application used the filesystem to manage the content, and now that I've moved everything to the database my code (php, perl) is much more compact and easier to manage, which translates to better usability and ease of further development.
  ----- Original Message ----- 
  From: working4aliving 
  To: pgsql-admin(at)postgresql(dot)org 
  Sent: Thursday, October 31, 2002 5:17 AM
  Subject: [ADMIN] To Blob or Not to Blob? THAT is the question.


  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.