DBIx::DataLookup 0.03

DBIx:DataLookup 0.03 is designed as a useful tool which can help you easily both cache records pulled by an SQL statement from a database in the memory as well as look them up later at any time during execution of your script.

This also speeds up access to your data at run-time and subsequently reduces load on the database.

For example, in your scripts, you could simply aggregate every SQL statement inside a hash in a config file and use them later to initialize a number of DBIx:DataLookup objects. Later in the code, you would simply invoke the get_hashref() method of your DBIx:DataLookup object(s) to retrieve records matching certain key values.

This module also supports alternative key mapping, which is not offered by any other module. A user of this module may add alternative key mappings at run-time to be able to link certain records with specific keys etc.

For example, if you have to deal with data supplied to you by various providers (such as news/weather syndicates etc), there's a chance for minor irregularities in otherwise similar data (say, two vendors use different identification codes for one theater ...) So, when you are talking of only a dozen (or fewer) such differing keys, key mapping offered by this module becomes quite handy.