[thelist] Photo Sharing Database

[Ann]

Thanks Rudy - I was hoping I had it set up right, I just wasn't sure.  I 
really appreciate the input!

Ann

--------------------------------------------------
From: "r937" <rudy at r937.com>
Sent: Wednesday, May 25, 2011 1:29 PM
To: <thelist at lists.evolt.org>
Subject: Re: [thelist] Photo Sharing Database

>
>> I am unsure of how to link the tables to ensure that
>> each student is linked properly to their albums
>
> you're actually already doing it, it's done here --
>
>  FOREIGN KEY (album) REFERENCES Students (s_id)
>
>> and that the photos are linked properly to the student
>> and the specific album.
>
> that's done here --
>
>  FOREIGN KEY (photo) REFERENCES Albums (a_id)
>
> each photo belongs to a specific album, and each album belongs to a 
> specific student
>
>
>> Also, I would like to store the photos in the database,
>> not a filing system.  Will this create problems with archiving?
>
> most people advise against this because of performance issues and the 
> difficulty of serving the image as an image after retrieving it in your 
> SELECT query that pulls it out of the database
>
> you're actually all set up to do it --
>
>   image MEDIUMBLOB
>
> go ahead, give it a shot, there are some benefits to doing this
>
> --
> rudy
> http://r937.com/
>
>
> -- 
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !