Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Parsing/manipulating CSV files

by tospo (Hermit)
on Oct 20, 2011 at 22:39 UTC ( #932773=note: print w/ replies, xml ) Need Help??


in reply to Parsing/manipulating CSV files

If you are handling the CSV files in Perl, you might also want to do the database interaction with your Perl scripts to keep it all together. It is possible to query/manipulate an MSAccess database from Perl using the DBI module. See DBD::ODBC


Comment on Re: Parsing/manipulating CSV files
Re^2: Parsing/manipulating CSV files
by Anonymous Monk on Oct 21, 2011 at 11:00 UTC

    In this particular instance, I'm looking to get rid of any reliance on MsAccess. It's purely accidental that I use Access now; it just happened that I could write the app within Access as a module as it was available at work so I could use their time to write it (and leave more time for beer at home).

    Database connectivity isn't a requirement for this, I want it to stand alone though I can see that it could be useful for future projects.

      If your data collection is large (for any value of large), DBD::CSV might grow (very) slow. For relatively small dtasets, DBD::CSV gives you instant relief: combining CSV files and selecting from one based on contents of others gets dead easy. When the dataset grows, and you still do not need a full relational dtabase like PostgreSQL or MariaDB, DBD::SQLite might be the interface of choice.


      Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (7)
As of 2014-08-22 04:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (146 votes), past polls