::help:: with complex table structure...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
zuidberg
Forum Newbie
Posts: 2
Joined: Tue Sep 03, 2002 9:20 am

::help:: with complex table structure...

Post by zuidberg »

hi!

i have to design a database which should manage a website's internal mail system with every user's own inbox/outbox. how should i store the mails themselves and how can i store, which mail is in which user's in- or outbox, as an outgoing mail is someone else's incoming mail and vice versa (one mail is in someone's inbox && someone else's outbox).

i think that's a rather complex data structure...and as i am new to database design - perhaps someone can give me a clue. i thank you all....:-)

wolfgang
User avatar
gite_ashish
Forum Contributor
Posts: 118
Joined: Sat Aug 31, 2002 11:38 am
Location: India

Post by gite_ashish »

hi,

if u want to build web based email web site... something like (yahoo, hotmail...), you should go for some kind of IMAP server.

for mails, mailboxes etc, using IMAP server is the best solutions rather that using database on our own.

you can use php's imap library for interfacing with the imap server.

php imap man page:

http://www.php.net/manual/en/ref.imap.php


Some of the most popular, fast, secure, production level, industry strength IMAP servers:

WU IMAP -- http://www.washington.edu/imap/
Cyrus IMAP -- http://asg.web.cmu.edu/cyrus/
Courier IMAP -- http://www.inter7.com/courierimap/

plus there exists free of cost web-based interfaces also... for the IMAP servers.... to name a few...

IMP Horde -- http://www.horde.org/imp/
Squirrelmail -- http://www.squirrelmail.org/


from sourceforge.net, google.com you can list many more of such products.

regards,
Post Reply