•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 422,388 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,720 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 558 | Replies: 2
 |
| |
•
•
Join Date: Apr 2007
Posts: 31
Reputation: 
Rep Power: 0
Solved Threads: 1
Light Poster
Hello everybody!!!!
I am just curious if I can make a database where all the data are images like bitmap, jpeg and other pictures format...
If yes, can you pls show me some code or sites to where I can learn a lot about this..
YOUR HELP IS HIGHLY APPRECIATED....
THANK YOU IN ADVANCED....
I am just curious if I can make a database where all the data are images like bitmap, jpeg and other pictures format...
If yes, can you pls show me some code or sites to where I can learn a lot about this..
YOUR HELP IS HIGHLY APPRECIATED....
THANK YOU IN ADVANCED....
•
•
Join Date: Sep 2007
Location: North Bay Ontario
Posts: 176
Reputation: 
Rep Power: 2
Solved Threads: 20
Junior Poster
It is generally more practical to save the path to the images in the database, rather than the images. This applies to any binary file. Let the OS file system take care of the files.
If you save the images in the database you have just doubled the disk space required to store the images. And what happens when an image is moved, renamed, or deleted?
Plus what is the point? The database can't search an image so why keep it in a database?
If you save the images in the database you have just doubled the disk space required to store the images. And what happens when an image is moved, renamed, or deleted?
Plus what is the point? The database can't search an image so why keep it in a database?
Last edited by trudge : May 2nd, 2008 at 5:35 am.
Amer Neely - Web Mechanic
"Others make web sites. We make web sites work!"
"Others make web sites. We make web sites work!"
•
•
Join Date: Dec 2007
Posts: 113
Reputation:
Rep Power: 1
Solved Threads: 13
Junior Poster
trudge is right, there is no point to save images in database. Displaying images from databse is relatively slow than filesystem. But if you still want to save images in database, take a look this small code snippest.
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode
•
•
•
•
age amd avatar backup blue gene breach business chips daniweb data data protection database development dos economy energy enterprise europe google government hacker hardware hp ibm ibm. news image recognition image search it linux medicine memory microsoft news open source openoffice pc ps3 recession red hat search security server sun supercomputer supercomputing technology trends ubuntu video search x86
- displaying image from database (PHP)
- how to save image into database (VB.NET)
- retieve image from database (ASP.NET)
- Download image from DB and view it... (C#)
- uploading image in database (PHP)
Other Threads in the MySQL Forum
- Previous Thread: help a newbie? mySQL find & replace
- Next Thread: SMS Message and Email Message
