Forum Index > MySQL > Image in database
|
|
| Author | Message |
|
Hey guys,
i was wondering have you ever tried the following method? (this i've seen in Plone (some CMS) and i'm not sure if its smart or not..) this is the situation: Plone gets installed ... installs its own server and database (can work with apache and mysql but we couldn't really configure it to work thatway ;)) there is no wwwroot or something like that its just the server; the plone isntallation files and a databse you can download some module wich would be like this i guess http://www.meka-meka.com/forum/viewtopic.php?t=276 so you can import zips with images wich are stored in the database.... okee thats the background info now comes the questions :D What would be the handy part of not using files anymore ? is it faster/smaller to store both text, image and design in database instead of .jpg .php and .css files ? or is it just 'another' method ... its i'm currently working on some mini CMS ... and comparing methods so i'm like why are they storing everything in database without any seperate files :D |
|
|
link to meka's post isn't what i thought it is :D i'm now reading that and its only showing filesize i thought it would open the file :D
also wondering how an images is stored in database then anyone knows how that works ? (can't open that database in plone ...) |
|
|
an image is stored as a 'blob'
|
|
|
ok and in youre opinion is this bettter then uploading the image itself to some directory or would it be exactly the same ??
|
|
|
it is better to have pic in dir... putting image as a block in db jus comsumes database size, and therfore slowing the database down...
|
|
|
Yeah totally, if you store the image binary data, it'll be stupidly pointless, and cause huge strain in your database...
Just simply store the image name etc.. in mysql database with the location it's in, and then a unique id for the image for searching etc.. incase you've md5'd the image title or got a random name generator on xD |
|
|
Forum Index > MySQL > Image in database
|
|