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

chaoticset on 2002-10-28T17:46:27

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...


SQLite

bart on 2002-11-06T20:18:08

A few days ago, somebody pointed me toward SQLite. 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.