http://www.perlmonks.org?node_id=1011770


in reply to Writing a database lookup tool

The data takes up about 8GB in a tab separated text file.

It might take about 8.2GB-10GB in sqlite -- not bad at all :)

Replies are listed 'Best First'.
Re^2: Writing a database lookup tool
by Anonymous Monk on Jan 05, 2013 at 09:26 UTC
    sqlite3 -- don't mess with sqlite2

      Why not spend some time familiarizing yourself with Catalyst or Dancer, and learn some MySQL? Using the DBI for MySQL it turns out isn't all that much more work than messing with SQLite...

        Why not spend some time familiarizing yourself with Catalyst or Dancer, and learn some MySQL? Using the DBI for MySQL it turns out isn't all that much more work than messing with SQLite...

        Why assume I'm not familiar with mysql?

        Who wants to manage deploying mysql (in addition to perl) on every target plaform , instead of DBD::SQLite?

        Mind you, I'm not the OP :)