in reply to perl database question

You sound like you need a crash course in Hashes.

Replies are listed 'Best First'.
Re^2: perl database question
by baxy77bax (Deacon) on Apr 26, 2008 at 19:34 UTC
    how do hashes deal with files up to several GB in size, i didn't have pleasant experience with hashes (too slow and too RAM consuming)
[reply]
      how do hashes deal with files up to several GB in size
      You will note this is the first time you mentioned gigs of data. What you had asked for was
      a convenient way to store, retrieve and query tabular data without having to rely on any external database engine or package.
      Hashes satisfy all four requirements quite nicely.

      Had you included this new requirement, I would have gone with one of the CPAN modules, even though that violates your fourth requirement.

[reply]

        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!

[reply]

In Section Seekers of Perl Wisdom