in reply to Re^2: The Eternal "filter.pl"
in thread The Eternal "filter.pl"

... it's a near firing offence if I do it as a skunkworks project and they won't allocate it willingly.

Can you use DBD::SQLite?

Replies are listed 'Best First'.
Re^4: The Eternal "filter.pl"
by Voronich (Hermit) on Aug 25, 2011 at 17:56 UTC

    Certainly not legitimately. The allergy to external code here is silly. But frankly I need to solve the problem, so that's not going to stop me if I can help it.

    But that's a question best answered by experimentation. The trick with sqlite is getting it installed in the right place.

    Me
      When you have a legitimate need, management is likely to listen; especially when you can put a cost to how much is attributed in manhours/salary to routinely solving similar "recursive" problems.

      I would suggest you discuss having some sort of development area where you could tackle such a task. You have a lot of data, so you probably need a better db engine, but if they aren't willing to give you the tools you need, perhaps you could daisy chain a few JET (MS Access) databases, to have something a little more robust and scalable.