procmail
[Top] [All Lists]

Re: Using procmail to deliver into a MySQL database

2006-02-23 06:56:22
Hello Gary,

Am 2006-02-20 14:35:36, schrieb Gary Funck:

Just curious - what do you plan to store in the SQL database? Just the
metadata (From:, To:, Date: and so on), or the entire message body?
What about atachments?  How will you index, and access the messages?
Perhaps there's an open-source solution that already does some of this?

I do this too.  :-)

I have only a couple of Headers (each a column) plus the full Body in
a seperate column.  For security reason, I save the FULL header in a
seperate column which will be cleared after one year (trigers works
automaticly).

My access interface is PHP5.

Body and attachments?

I split them on the fly using PHP5

Greetings
    Michelle Konzack
    Systemadministrator
    Tamay Dogan Network
    Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/3/88452356    67100 Strasbourg/France   IRC #Debian (irc.icq.com)


____________________________________________________________
procmail mailing list   Procmail homepage: http://www.procmail.org/
procmail(_at_)lists(_dot_)RWTH-Aachen(_dot_)DE
http://MailMan.RWTH-Aachen.DE/mailman/listinfo/procmail