Re: [SLUG] MySQL Document Storing

[Paul Robinson <Paul.Robinson@nospam.mq.edu.au>]

At 12:47 PM 1/06/00 +1000, [-SwM-] wrote:
>Daron,
>
>Just load the entire contents of the file into a field of the table. I
>would not, however recommend this if you plan to have a large number of
>rows in the database. A better solution is to store the file path in the
>database and use perl to read this address and catenate the file from the
>filesystem itself.
>
>Gavin Sherry
>Editor - LinuxWorld.com.au


I agree with this, mainly because it's what I did for a site that needed 
files uploaded. Although the one I worked on used php & mysql the principal 
is the same, store the path/url into a field and write something to store 
the files on the filesystem in some sort of logical order..

Cheers,
Paul


-----------------------------------------------
Paul Robinson
Senior Web Developer
Centre for Flexible Learning
Macquarie University
NSW 2109, Australia
Voice: +61 2 9850 8424
Email: Paul.Robinson@nospam.mq.edu.au
-----------------------------------------------

--
SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
To unsubscribe send email to slug-request@nospam.slug.org.au with
unsubscribe in the text