I would suggest that you do not store the photos in the database.  Rather,
store the directory/ file name where each photo is located on the weberver.
This should decrease access speeds and reduce size of DB.

have fun with this project.  It sounds like a good start.

Richard Emery
Excel Communications, Inc.
IT Sr. Project Manager
(972) 478-3398
(972) 944-0542 (pager)

There is no "trying"...
There is only "Do" or "Not Do"



-----Original Message-----
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 10:31 AM
To: PHP-DB
Subject: RE: [PHP-DB] Photo Album Schema


Thanks for the suggestion but this is a personal project to be used
for learning and as a place for friends to post photos with only the
features
that we all want.
Jeff Oien

> This has been done.  see http://www.photopoint.com
> 
> This is a free service available to the public.
> 
> rick
> 
> Richard Emery
> Excel Communications, Inc.
> IT Sr. Project Manager
> (972) 478-3398
> (972) 944-0542 (pager)
> 
> There is no "trying"...
> There is only "Do" or "Not Do"
> 
> 
> 
> -----Original Message-----
> From: Jeff Oien [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 10:12 AM
> To: PHP-DB
> Subject: [PHP-DB] Photo Album Schema
> 
> 
> I want to make a photo album that will have users who sign up
> to create an album and then have the albums open to the public.
> I was thinking of doing it like this but I've never done a relational
> database before so if anyone thinks of anything I should change
> please let me know. Thanks.
> Jeff Oien
> 
> Table1:
> -username
> -password
> -album_title
> -creation_date
> -id
> 
> Table2:
> -id (from Table1)
> -photo (jpg or gif)
> -date
> -photo_title
> -description (limited length)
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to