JP Vossen on 18 Jul 2011 21:08:57 -0700


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

[PLUG] DBD:CSV, DBD::AnyData & M$ "Log Parser"


Last night at PLUG W I was trying to recall the name of the Perl DBI/DBD "driver" that allows you to read and write CSV (and other, I thought) files as if they were SQL DBs.

I knew I'd seen it, and I was trying to follow it up after writing some brute-force Perl code to clean up some cruft in my rhythmdb.xml file. So I was Googling for "perl DBD XML" and finding only DBD::AnyData, which looked cool but wasn't ringing any bells. I also wasn't finding it in the PLUG ML archives.

When I got home I thought to Google "perl dbd cvs" and the #1 hit was of course DBD::CVS. <face-palm>

Either way, pretty cool stuff.

http://search.cpan.org/~hmbrand/DBD-CSV/lib/DBD/CSV.pm
http://search.cpan.org/~rehsack/DBD-AnyData-0.110/lib/DBD/AnyData.pm

Also semi-related, a free tool from M$ called the "Microsoft Log Parser" that does similar things, see my previous post: http://lists.netisland.net/archives/plug/plug-2009-08/msg00179.html

AAAAARRRGGGGHHHHHH!!!!!!! And *there* is the darn reference to DBD::CVS! I *knew* I sent that to PLUG, but I couldn't find it in the ML archives because I was still searching for the wrong name! <double-face-palm>

Later,
JP
----------------------------|:::======|-------------------------------
JP Vossen, CISSP            |:::======|      http://bashcookbook.com/
My Account, My Opinions     |=========|      http://www.jpsdomain.org/
----------------------------|=========|-------------------------------
"Microsoft Tax" = the additional hardware & yearly fees for the add-on
software required to protect Windows from its own poorly designed and
implemented self, while the overhead incidentally flattens Moore's Law.
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug