YaRness
07-17-2001, 11:18 AM
ok say i've got a database. i've got people sending email to somespecialaddress@mycompany.com. the stuff i want is in the body of the message, no attachments.
i could:
1) run a retrieval when i start up the database client. pretty easy in *nix, just parse out stuff from the email file (i forget where that is atm, but i know there's just plain old text files somewhere to grok). i would assume that windows servers would have something at least vaguely similar (*crosses fingers).
2) prolly a better method: have some daemon that harvests stuff from the emails when they are received and plugs them into a database (prolly into a queue table of some sort for later entry into other tables, but these are details that we don't really care about just yet). this i'm sure could be done in *nix, but i'm not familiar with how (yet). setting up something like that in windows sounds really scary as well.
3) ?
later of course all of these this will include some method of decryption, since the emails will prolly be PGP (or some other standard) encrypted.
this will almost certainly be a sql database (prolly mysql), but i dunno if that detail is important atm.
basically i guess i'm looking for a kick in the right direction, or any other comments.
i could:
1) run a retrieval when i start up the database client. pretty easy in *nix, just parse out stuff from the email file (i forget where that is atm, but i know there's just plain old text files somewhere to grok). i would assume that windows servers would have something at least vaguely similar (*crosses fingers).
2) prolly a better method: have some daemon that harvests stuff from the emails when they are received and plugs them into a database (prolly into a queue table of some sort for later entry into other tables, but these are details that we don't really care about just yet). this i'm sure could be done in *nix, but i'm not familiar with how (yet). setting up something like that in windows sounds really scary as well.
3) ?
later of course all of these this will include some method of decryption, since the emails will prolly be PGP (or some other standard) encrypted.
this will almost certainly be a sql database (prolly mysql), but i dunno if that detail is important atm.
basically i guess i'm looking for a kick in the right direction, or any other comments.