RE: [PHP-DB] Photo Album Schema
| From: | Rick Emery | Date: | Tue, 21 Aug 2001 15:37:09 +0000 |
| Subject: | RE: [PHP-DB] Photo Album Schema | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11607@lists.php.net to get a copy of this message | ||
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:jeff@webdesigns1.com]
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:jeff@webdesigns1.com]
> 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net