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
Innocent, Your Honor. Perl users build small tools all day long.
--Larry Wall in <1992Aug26.184221.29627@netlabs.com>
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
CSV Databases (Score:1)
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 app through its paces and then run the validation code to see if anything doesn't validate.
Reply to This