All the Perl that's Practical to Extract and Report

Navigation

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
Without JavaScript enabled, you might want to
use the classic discussion system instead. If you login, you can remember this preference.

Please Log In to Continue

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