Home » SQL & PL/SQL » SQL & PL/SQL » Storing image in database
Storing image in database [message #385813] Wed, 11 February 2009 03:24 Go to next message
atulwagh
Messages: 18
Registered: June 2007
Location: Mumbai
Junior Member
Hi,
I want to store image in database.
There are usually two approaches for that:
1]The data is stored in the database as LOB fields (BLOB for binary and CLOB for character data),
2] in OS files with the references to the files stored in the database.

Can anyone tell me which one is better??


Thanks & Regards,
Atul
Re: Storing image in database [message #385817 is a reply to message #385813] Wed, 11 February 2009 03:32 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If one of them was strictly better than the other, then only one would exist.

Storing them in the Db means that your images will be backed up, and are more secure, but they can only be accessed via the Db. It may well also adversely affect your backup times if you have a large volume of images.

Storing them as Bfiles means they are less secure, but can be accessed other than via the Db.
Re: Storing image in database [message #385822 is a reply to message #385813] Wed, 11 February 2009 03:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Application Developer's Guide - Large Objects
Part I Getting Started
Chapter 1 Introduction to Large Objects
Section Different Kinds of LOBs

Regards
Michel
Re: Storing image in database [message #385872 is a reply to message #385813] Wed, 11 February 2009 11:12 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
i was comfortable on storing gif files in BLOB through oracle XE, apex 3.1.2. I have not experimented on other modes.
yours
dr.s.raghunathan
Previous Topic: Merge Statement with PL/SQL Collection type
Next Topic: Tuning a query
Goto Forum:
  


Current Time: Sat Dec 10 09:01:15 CST 2016

Total time taken to generate the page: 0.07760 seconds