Re^2: CSV regex with hash/array program plan

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

Comment on Re^2: CSV regex with hash/array program plan

Replies are listed 'Best First'.
Re^3: CSV regex with hash/array program plan by GrandFather (Saint) on Nov 24, 2014 at 20:30 UTC
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]

Replies are listed 'Best First'.

Re^3: CSV regex with hash/array program plan
by GrandFather (Saint) on Nov 24, 2014 at 20:30 UTC

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]