Page 1 of 1

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

Posted: Tue Sep 03, 2002 9:20 am
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

Posted: Tue Sep 03, 2002 9:58 am
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,