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)

Wednesday June 26, 2002
02:33 PM

Bitchin'

[ #5975 ]
Problem: DBD::CSV doesn't provide some of the functionality Mike wants us to have (like auto-incrementing fields and whatnot).

Decision: See if I can get a MySQL server working on my Win32 system.

Outcome: Yee-haaawwww! Downloaded it, unzipped it, installed it...it just WORKS!

Now, to point Newser's code (the new name for this thingy) at MySQL and continue work. The due date is Monday. Luck, schmuck...I'll need a small miracle for this thing to look good. :\

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • DBD::SQLite (Score:4, Informative)

    by Matts (1087) on 2002.06.26 15:22 (#10028) Journal
    If you want something light (i.e. no external dependancies) like DBD::CSV, but that gives you more powerful SQL features (like auto-increment), check out DBD::SQLite. It's also probably faster than MySQL (and most certainly faster than CSV).
  • If, for some reason, you do get stuck using a CSV database, you can check out my CSV database validation [perlmonks.org] program. It will allow you to create a CSV database and validate unique fields, foreign key constraints, and simple data types. You can even use a regex for a data type.

    The only limitation that I'm aware of is that it validates a database, but as a "one-time" thing. Thus, you can't use it at run time (though I'm sure it could be hacked...). I think it's great for testing CSV applications. Put your