1) Does this sound like a reasonable approach to the problem, given the relatively low amount of detail I've provided? Anyone dealt with this type of thing before and have any gotchas for me?
I can't say anything about gotchas, but I would look at trying to eliminate the mail step. It might be possible to directly query the resource monitors, or modify them to do the database entry instead of mailing.
Of course, that depends on what you are doing. If you have a standard 'alert format' that everything uses, and mails to the same address, from all over a large site/company, where every system has it's own alert generator, this may be the best way. Just saying to check if they are all a couple line Perl scripts, then it may be you can create a database entry template and stick it in instead of the email code.
2) From what I've read, Postgres beats MySQL performance-wise, which is why I chose it, but IANADBA. Any votes on a free DB to use for this? Obviously, it needs to have a perl interface or CPAN module available. Regardless of which DB you like, what's your favorite module for interacting with it? ...and, umm, if you could point me to any "Getting Started" docs, that would be just lovely. <:)
The DBI modules are what you want to use here. If you use them correctly it almost doesn't matter what database you are using (at least to the programmer).
I'd recommend the book 'Programming for the Perl DBI' as an intro. It goes over everything you're likely to need. (O'Reilly press.)
As for DB... It would depend on what you need out of it. A little googling will bring up sites with the advantages and disadvantages of the various DBs for you, with some explanation of when you should care about each.
3) Which module would you suggest for parsing email? There are a few of them out there, and I really don't have the time to try each one out until I find the one I like the best. :)
I've been just doing some research into this for a project I'm working on, and have been impressed by the Mail::Box module set. Of course, ask me in a couple weeks and my answer may change... But generally that module set looks to be able to do anything you would want to do with email.
Daniel T. Staal
--------------------------------------------------------------- This email copyright the author. Unless otherwise noted, you are expressly allowed to retransmit, quote, or otherwise use the contents for non-commercial purposes. This copyright will expire 5 years after the author's death, or in 30 years, whichever is longer, unless such a period is in excess of local copyright law. ---------------------------------------------------------------
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
