Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^3: Writing Program With Hashes and Loops For Files With Data in Columns

by ww (Bishop)
on Mar 05, 2013 at 18:07 UTC ( #1021883=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Writing Program With Hashes and Loops For Files With Data in Columns
in thread Writing Program With Hashes and Loops For Files With Data in Columns

It may be worth considering dumping the milcar file into an SQLite database, using Perl to get your data from file2, and then using the modules DBI & DBD::SQLite along with SQL's native functions to find db-matches against file2's fname, lname.

That's not to claim I'm sufficiently expert with dbs to guarantee that this is the best approach but -- based on limited experience with (mostly) toy-applications -- it looks pretty plausible to me and DBI and DBD::SQLite will make the learning curve much shallower while the SQL capabilities can handle most of your search, sort and write requirements.


If you didn't program your executable by toggling in binary, it wasn't really programming!


Comment on Re^3: Writing Program With Hashes and Loops For Files With Data in Columns
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1021883]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (12)
As of 2014-09-16 17:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (40 votes), past polls