in reply to Re^3: perl database question
in thread perl database question

Beg your pardon? Hashes support just one type of lookup. Exact match. Please show me how do you store data in hashes so that you can efficiently select all rows in which the value of a certain column is between X and Y? Or those in which a different column contains data that start by ABCDEF? Also keep in mind that in a hash you only have one key ... most likely when working with tabular data you do not always search by the same column, even if you did always ask for an exact match.

I think he meant "external" to Perl ... some piece of software completely unrelated to Perl that has to be installed. So DBI+DBD::SQLite does fit the bill.

Jenda
Support Denmark!
Defend the free world!

Replies are listed 'Best First'.
Re^5: perl database question
by apl (Monsignor) on Apr 26, 2008 at 23:55 UTC
    I think he meant "external" to Perl ...
    A lot of the initial discussion was certainly predicated on assumptions; there was not a lot of detail in the request.

    For example, I assumed we were talking about half a million or less records, each with a primary key and possibly a secondary key. Given my assumptions, it's not too painful to use a Hash of Hashes. For exact queries, the hash is a Big Win. For a partial query, doing a foreach through the hash isn't that painful.

    As soon as the OP mentioned he was talking gigabytes of data, I withdrew my original suggestion.

    So DBI+DBD::SQLite does fit the bill.
    I agree completely.
[reply]

In Section Seekers of Perl Wisdom