in reply to CSV regex with hash/array program plan

Have you freedom to use a database instead of .csv files? SQLite (see DBD::SQLite) may fit the task better.

Perl is the programming world's equivalent of English
  • Comment on Re: CSV regex with hash/array program plan

Replies are listed 'Best First'.
Re^2: CSV regex with hash/array program plan
by campus1plb (Initiate) on Nov 24, 2014 at 19:42 UTC

    Hi Grandfather, yes i have the freedom to solve this problem in any way i see fit. Alas i've no experience with SQL, but i'd be willing to learn (and at some point soon i shall need to as the eventual destination for this data will be an SQL database

    My plan was to do the regex and matching first, then to populate a database with that (i actually need to create a mathmatical construct or coding system for the subject "hits" before that however

    Any suggestions on an alternative welcomed, i'm trying to spend lots of time on the planning, whilst i re and upskill myself in Perl, so open to any wisdom!

    best wishes Phil

[reply]

      It's refreshing to have someone open to, nay keen to, embrace new technologies! To dip your toe into databases writ Perl and SQL you may find Databases made easy helpful.

      I'd be somewhat inclined to skip the CSV phase if you can because it will skew the way you think about structuring the database. Call back here when you have a structure in mind and ask for comment.

      Perl is the programming world's equivalent of English
[reply]

In Section Seekers of Perl Wisdom