[prev in list] [next in list] [prev in thread] [next in thread] 

List:       procmail
Subject:    Re: Using procmail to deliver into a MySQL database
From:       Michelle Konzack <linux4michelle () freenet ! de>
Date:       2006-02-22 14:47:27
Message-ID: IJlfjC.A.5z.1hb_DB () mobilix ! private
[Download RAW message or body]

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@lists.RWTH-Aachen.DE
http://MailMan.RWTH-Aachen.DE/mailman/listinfo/procmail

[prev in list] [next in list] [prev in thread] [next in thread]