Re: CSV Diff Utility

This may be the old hammer-maintainer sees all things as nails, but if you use DBD::CSV you can leverage Text::CSV_XS's parsing speed and SQL's sorting and selecting options and DBIx::*'s rich set of output formats. If speed is an issue, use DBI::SQL::Nano as DBD::CSV's parser instead of SQL::Statement - it's much more limited but also much faster for simple key-field queries.

Or then again, maybe you're asking about search logic rather than software, in which case the answer could depend on a the best combination of Perl and SQL processing.

Comment on Re: CSV Diff Utility

Replies are listed 'Best First'.
Re^2: CSV Diff Utility by Limbic~Region (Chancellor) on Jun 23, 2004 at 12:22 UTC
jZed, I absolutely hate it when I see people reply to proposed solutions with "That won't work". Sometimes it is followed by "because <lame excuse>". My favorite is "because I don't have permission to install modules" where the module in question is pure Perl. With that said, I do not know if this will work, but I can't go into specifics as to why because of, yes here it comes - the lame excuse you have all been waiting for, my government employer. Now, since I already doubt any solution I come up with will be used and it looks like there may not be an existing solution - I intend to fully explore this just because it sounds interesting. Cheers - L~R	[reply]

Replies are listed 'Best First'.

Re^2: CSV Diff Utility
by Limbic~Region (Chancellor) on Jun 23, 2004 at 12:22 UTC

jZed

With that said, I do not know if this will work, but I can't go into specifics as to why because of, yes here it comes - the lame excuse you have all been waiting for, my government employer.

Now, since I already doubt any solution I come up with will be used and it looks like there may not be an existing solution - I intend to fully explore this just because it sounds interesting.

Cheers - L~R

[reply]