Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

Re: Re: OT: Images into MySQL database

by Ryszard (Priest)
on Jan 25, 2003 at 05:59 UTC ( #229800=note: print w/replies, xml ) Need Help??

in reply to Re: OT: Images into MySQL database
in thread Images into MySQL database

I think it is inadvisable to have the database point to a file in the filesystem

I understand what you're saying here (someone can change a file to be something you dont want it to be) regardless of the optimisations in a modern RDBMS it is generally considered a more scalable solution to put the images on the disk and a pointer in the db.

Of course if you've a low volume site that is lite on graphics, it may well be better to keep your graphics in a DB.

Unfort, i dont have any metrics handy to backup my claims here..:-(

Replies are listed 'Best First'.
Re: Re: Re: OT: Images into MySQL database
by CountZero (Bishop) on Jan 25, 2003 at 08:37 UTC

    I agree with your point of view as long as we are strictly speaking within a webserver environment. Webservers are of course optimised to serve files (of whatever nature) and the security-issues can be well managed there.

    However, if you are just thinking of accessing the database directly (without going through a webserver first) I still think it is best to store the images in the database itself.

    Of course the reference to in the original question should have tipped me of that this was a web-server related matter.


    "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://229800]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (5)
As of 2023-06-01 12:34 GMT
Find Nodes?
    Voting Booth?

    No recent polls found