Re: FN-FORUM: Strategy for image and data storage

date posted 10th August 2004 21:49

At 22:26 on Tuesday, 10 Aug 2004, Paul Evans wrote:

>
>> supposing I store the original file on the server, with both the
>> original filename reference in the item record and the random coded
>> upload filename (to avoid overwriting by duplication)
>
> yep!
>
> if I was building these bits from scratch, there would be two data
> tables...


Ah..

now that turns it on it's head, but makes a lot more sense.

I should be uploading images and recording image data completely
seperately to the item entry process.

maybe even batch uploading....

then what I could do is present a controlled search of images, and then
the user could tick select the ones they want for the item record they are
adding. (I forgot to mention image galleries on a single item... - 3 pages
of a scanned magazine article for example) and then each would be
automagically linked...

Cheers

I think I can see it now...