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

From: "working4aliving" <working4aliving(at)hotmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: To Blob or Not to Blob? THAT is the question.
Date: 2002-10-31 13:17:53
Message-ID: OE56k4ruJfE9MswF0Ss000041aa@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2002-10-31 15:05:51 array character types
Previous Message Andrew Perrin 2002-10-31 12:49:22 Re: URGENT: undoing a mistake