• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: images in database... a suggestion
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Prev by Date: Re: WO license costs
  • Next by Date: WO example sites
  • Previous by thread: Re: Flash XML help
  • Next by thread: Re: Re: images in database... a suggestion
  • Index(es):
    • Date
    • Thread