I appreciate your response but people have debated the usage of BLOBs for a long time so I don't think we should here. Our development team looked at the possibilities for this project and decided on BLOBs. Most of the time we have used the file system. Thanks for your suggestions.
On Mar 19, 5:33 am, burzum <[email protected]> wrote: > I don't see any real "advantage" in any of the listed so called > advantages. > > >Referential integrity (ACID Consistency) > > Doesnt matter, the file is there or not in the FS. > > >Ease of backup > > Also just one command to pack the files with your favorit compression > programm. > > >Saving of Inodes > > A FS does this similar to manage itself, as the article also states. > No (dis-)advantage at all, its necessary. > > >Easy categorisation > > See below storage of meta data > > >No Name collisions > > UUID > > >Storage of Meta Data (data about data) > > You store the info about the file in the database, not the file, and > get it when it is uploaded. You make the database faster by not > storing the files inside of and and just its meta data. > > >Central point of operations > > APP/files > > >Replication over multiple servers > > Unnecessary by using the FS on a good RAID driven storage system. You > can also mount each directory from another server. I dont see any > advantage for the DB here. Neither speed wise nor by an easier backup. > > On Mar 18, 4:32 pm, Daffy <[email protected]> wrote: > > > Faifas, I'll try your suggestion. Thanks. > > > Burzum, there are many good reasons a developer might save images in > > the database. See here for more > > information:http://www.phpro.org/tutorials/Storing-Images-in-MySQL-with-PHP.html#1 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
