RE: [PHP-DB] Re: blob

I agree with Dave. I wrote an application to allow a client to upload/manage images and categorise them into diff. parts of their website. Images were stored as normal image files after upload and a pointer made to them from the appropriate database record (which had additional image info e.g. description) Since I now have to move this website to a new server -> transferring all these files was a bit annoying. Storing them as binary data in mysql would have been easier to manage... -----Original Message----- From: David Smith [mailto:DavidSmith@byu.net] Sent: Wednesday, 8 January 2003 10:19 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: blob On Tue, 2003-01-07 at 15:52, Jeffrey_N_Dyke@Keane.com wrote: > > I agree with this method. i have not yet seen an advantage of storing > blobs in a database. Is there one? i'm sure those on this list would have > an opinion if there was one. personally, i like storing all this stuff on > the file system. There is one advantage. You must either chown the upload directory to the user that your web-server runs as, or chmod it to be world-writable. When creating a web-application that you plan to distribute (like Slashcode), you can't assume that your users will have that privilege. So, storing it in MySQL is a great option. --Dave -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php