more useful options | |
PerlMonks |
Re: Query Language with Flat Filesby Marshall (Canon) |
on Sep 18, 2009 at 19:21 UTC ( [id://796187]=note: print w/replies, xml ) | Need Help?? |
I suggested earlier, DBD::CSV. This is a "full DB" that uses a CSV (Comma Separated Value) file. The advantage of this is that since it uses a "flat" CSV data file, you can easily 1)create the initial DB, 2) watch what happens as you run SQL statements. This module is used like you'd use a massive commercial DB...you connect to the DB, then run SQL on it. It handles multiple processes and deals with all this lock stuff. You have a simple data structure. Learn how to use basic SQL with something easy. The code (connect to DB, SQL stuff) will all be same on a bigger DB. The difference will be that on a higher performance DB, you can't just "cat" the DB file to see what is going on. You have a "wimp" DB. I mean 15K records with 5 fields that can be represented as a "flat" file, and that is only updated 3 times per minute, is "nothing". It will be fast enough. Get the code working then think about something more sophisticated.
Update:
In Section
Seekers of Perl Wisdom
|
|