Require Help regarding Mysql Database (Urgent).

[hassanmuneer]

AOA

i use mysql with RH9.and want to save some images in database (gif,jpeg).if anyone know that how to save image file in mysql .Plz Guide me. and i also require help regarding retrive data with the help of c.I know about the c API that is used to retrive data.but i want to discuss some problem with a person that already work on it.

Regards

Ask not what your country can do for you, Ask what you can do for your country

[jargon]

You are looking to store binary data, this seems to be a good reference.
http://www.phpbuilder.com/columns/florian19991014.php3

[zaeemarshad]

I would suggest you store the image on the filesystem as a normal file and store the path info in the database. That wont make ur database grow very large . just my 0.02$

cheers
zaeem

[asaf]

Zaeem's advice is good. You can place a link to the images in the database. However, if you still would like to place the images in the database, the type to use is blob or binary large object.


my 2 cents.

asaf

[saquib_javed]

disagree

approach is wrong

that guy dont wana use the filesystem

infact in my final year lecture our teacher gave us assignment on this we did it by storing the path of the file but our teacher said 'NO'

[farhantoqeer]

how did he defend his No?

What was the scenario?

[saquib_javed]

Dear,

He said NO by giving the reason that if ur on remote system and u want to insert a particular image (from remote system) in databse then it should not store the path because it can be deleted by anyone or anything.

ThanX

[hassanmuneer]

Thanks for the responses.

[hassanmuneer]

And both the solutions are right depend on the senario , we can save the pictures to the databases and we can also save the paths to the databases. But the later technique is uses in the web enviroment. to reduce the size of the database. But my question is if we save the images in DB or in file system we use the same resources of the system ( i mean storage). The senario is if i want to host my application is some US based server and use the database for storing the images it consume the same space as OS file system and what do you mean by heavy database.
DB are meant to store the information not for the meta data information.

i am waiting for your responses.

[lambda]

But my question is if we save the images in DB or in file system we use the same resources of the system ( i mean storage).

no, you always use slightly more resources if you store them in a database: there's the overhead of database tables, indexes, etc. it's also slower to fetch images from a database, you can't get the web server to cache the images in memory (done automatically if the image is served from a local disk), etc. in other words, more cpu resources to serve an image.

The senario is if i want to host my application is some US based server and use the database for storing the images it consume the same space as OS file system and what do you mean by heavy database.

who said anything about a heavy database?

DB are meant to store the information not for the meta data information.

if you have to store a billion images (not unimaginable -- see sites like livejournal.com where paid users can upload hundreds of avatar-type pictures), you really don't want to store all that in a database.

besides, if you store the path to a file in the db, you're storing information: metadata is information.