Re: images in database... a suggestion
Re: images in database... a suggestion
- Subject: Re: images in database... a suggestion
- From: Thomas Pelaia II <email@hidden>
- Date: Fri, 09 Dec 2005 08:36:00 -0500
Amedeo,
We've developed an electronic logbook that stores everything (text,
images, attachments) in an Oracle database. It has been running
probably for about three years now and has been working very well, so
far.
Personally, I prefer the database approach. There are at least a few
advantages. Here are a few:
- It facilitates sharing of data among desktop applications, scripts
and web apps. Since everything is in a single database, data can be
shared without the need for complex rules for finding data. In our
case the WebObjects based logbook is not the only application that
has access to our database. Everything is integrated and the
database provides the common storage. If you place your images in a
web server, suddenly you are limiting access to web based
applications and cutting out others (or at least making it more
challenging for others) to access them. This may not be a compelling
issue for your company.
- It simplifies backup. Simply backup the database and all data will
be consistent. If you keep files in a separate place, it is more
difficult to synchronize backups. Again this may not be an issue for
you.
- In general, well designed database schemas provide good
organization and are more flexible when you decide to change the
organization (no stale links since the links are dynamic).
Performance is plenty good for us, however we are serving hundreds of
users, not millions. We have a lot of data including images and
attachments, and the size continues to grow, but as I mentioned we
don't have millions of people accessing it.
-tom
On Dec 9, 2005, at 8:16 AM, email@hidden
wrote:
Message: 12
Date: Fri, 9 Dec 2005 12:47:13 +0100
From: Amedeo Mantica <email@hidden>
Subject: imeges in database... a suggestion
To: webobjects-dev Development <email@hidden>
Message-ID: <email@hidden>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Hello, I have a products database...
Products contains images...
what is better...?
1) insert images directly into database as BLOB / NSData
2) upload (automatically) file in a directory and store into database
only the file reference? (I do this actually)
Best regards.
Amedeo
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden