RE: uploading and downloading files to MySQL (--2--)

2003-01-09 Thread Westgate, Jared
Mariusz wrote: > What type of field should I use for storing the path; just > VARCHAR I guess? > And as far as the filenames - make up some random file name for each > submitted file? This is a little off topic for a Perl list, but I'll give it a shot. Be forewarned, that I do not know much a

Re: uploading and downloading files to MySQL (--2--)

2003-01-09 Thread R. Joseph Newton
t;[EMAIL PROTECTED]> > To: "Mariusz" <[EMAIL PROTECTED]> > Cc: "perl" <[EMAIL PROTECTED]> > Sent: Thursday, January 09, 2003 2:13 AM > Subject: Re: uploading and downloading files to MySQL > > > Hi Marius, > > > > Why do it? Dat

Re: uploading and downloading files to MySQL (--2--)

2003-01-09 Thread Mariusz
: "R. Joseph Newton" <[EMAIL PROTECTED]> To: "Mariusz" <[EMAIL PROTECTED]> Cc: "perl" <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 2:13 AM Subject: Re: uploading and downloading files to MySQL > Hi Marius, > > Why do it? Databases are

Re: uploading and downloading files to MySQL

2003-01-09 Thread Vitaliy Babiy
I don't think it's good idea to store files in DB. Especially big files like music... The common way is to store path_to_files in DB "Mariusz" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, I found some info on how to upload files into a directory on the

Re: uploading and downloading files to MySQL

2003-01-09 Thread R. Joseph Newton
Hi Marius, Why do it? Databases are designed for organization of large table and information about the relationships between theri attributes. I would suggest going light, storing only the filename of an image in the db, and stroing the images files themselves as files. Joseph Mariusz wrote

uploading and downloading files to MySQL

2003-01-08 Thread Mariusz
Hi, I found some info on how to upload files into a directory on the server and I was able to do that but can anyone tell me how to upload a file to my database (MySQL)? I know to use BLOB for the field type (which BLOB depending on the size) but how do I construct the INSERT or is there a diff