Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

mysql db for image storing

Familiar Sight
  
Join Date: Jan 2008
Posts: 198
#1: Sep 3 '09
I want to develop web site for vehicle sale. There I want to store vehicle images. I'm planing to use mysql DB. Please tell me is it possible to user mysql db for that kind of data storage?
code green's Avatar
Expert
  
Join Date: Mar 2007
Location: England
Posts: 1,076
#2: Sep 3 '09

re: mysql db for image storing

Yes. The data type is blob.
But I personally belive it is better to store the filepath/filename and store the images in a folder.
This means simple image updates and a smaller DB
mwasif's Avatar
Moderator
  
Join Date: Jul 2006
Location: Pakistan
Posts: 718
#3: Sep 4 '09

re: mysql db for image storing

It is always recommended to store the images as files as code green suggested unless you have some special requirements to store the images in the DB.
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved