Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

chaoticset (2105)

chaoticset
  (email not shown publicly)
http://chaoticset.perlmonk.org/
AOL IM: chaoticset23 (Add Buddy, Send Message)
Yahoo! ID: illuminatus_foil (Add User, Send Message)
JAPH. (That's right -- I'm not Really Inexperienced any more.)

I'm not just here, I'm here [perlmonks.org], and here [javajunkies.org] too, I ramble randomly in my philosophical blog [blogspot.com] and my other blog [blogspot.com]. Soon I'll come in a convenient six-pack.

Journal of chaoticset (2105)

Monday October 28, 2002
12:46 PM

SQL: It's Not Just The Noise You Make Stepping On A Slug

[ #8644 ]
Now that I've got the code working to separate suspicious email from benign email, I have to figure out a way to store data about the benign email so that there's not 19 extra megs of nothing taking up space on the server. (Mo' code, mo' problems, if you will.)

So the next step is the one I had prepared for originally: Parsing email files. NBD, I've got most of the code for this written (specifically one beefy little sub that scans the file, snips out the from/to/subj/body, etc.) Just need to modify the sub so that it only returns from/to/subj/time/length and then make the script dump this in a CSV database.

"Que?" you say. "CSV? Greg, isn't there already some database server in place?"

Yes, there is. Do I know how to get to it? Not yet. I want a working solution ASAP, and I can build something to drop the CSV data into an actual database later in twenty minutes. Right now I need to get cracking on three major things.

  1. The GUI for Censoraid
  2. Which Linux distro would be best (or at least feasible) for the hardware available (which I have yet to see)
  3. The CSV thingy-dingy. (If they're really dead-set on keeping archives of the email, I can probably provide some sort of automated decompression utility to at least save space instead of just taking up oodles everywhere.)

I love it when a plan starts to come together...


List all Journal entries
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

SQL: It's Not Just The Noise You Make Stepping On A Slug 1 Comment More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • A few days ago, somebody pointed me toward SQLite [sqlite.org]. I've played with it a little, and it looks indeed very interesting. There's a DBD "driver" for it; well actually, it's the complete database engine in the shape of a DBD driver [cpan.org].
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.