Lightweight storage solution?

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Lightweight storage solution? by Corion (Patriarch) on Jul 24, 2008 at 15:30 UTC
See Tie::File or DBD::SQLite. You haven't stated what kind of queries you make against that file and what kind of portability you need, so it's hard to be more specific with recommendations. Storable also can be considered as a persistence solution.	[reply]
Re^2: Lightweight storage solution? by Anonymous Monk on Jul 24, 2008 at 15:48 UTC
The only queries I would need to perform are checking to see if the number is listed in the file/DB or not.	[reply]
Re^3: Lightweight storage solution? by broomduster (Priest) on Jul 24, 2008 at 16:04 UTC
Is this one list of numbers, or is it a bunch of (labeled) lists of numbers. If the former, then a db solution may not really buy you anything. In that case just read the file and `grep` for your target(s).	[reply] [d/l]
Re: Lightweight storage solution? by dHarry (Abbot) on Jul 24, 2008 at 15:41 UTC
Why do you want to change? The file is very simple, a database seems overkill. Do you need support for concurrency? Is the file getting BIG? Something else?! There are many lightweight databases around. You might want to give CPAN or sourceforge a look. Personally I would probably try my luck with MySQL. maybe not so lightweighted but a lot lighter then beasts like Oracle, Sybase, MSSQL, Progress etc. etc. Installation and administration is straightforward, i.e. you don't have to be a DBA. Hope this helps	[reply]
Re: Lightweight storage solution? by zentara (Cardinal) on Jul 24, 2008 at 17:51 UTC
What about Storable ? It is easy to use, just save and reload a hash to a file. I use it in ztkdb I'm not really a human, but I play one on earth Remember How Lucky You Are	[reply]
Re: Lightweight storage solution? by broomduster (Priest) on Jul 24, 2008 at 15:33 UTC
I `use DB_File;` [download] with tied hashes a lot for this kind of thing. Since your "values" appear to be lists (as opposed to scalars), you may also need to `use MLDBM qw(DB_File Storable); # or other choice of Serializer` [download]	[reply] [d/l] [select]
Re: Lightweight storage solution? by Anonymous Monk on Jul 24, 2008 at 15:36 UTC
Anyone familiar with DBM::Deep? Looks like it might be perfect and it's a pure perl solution.	[reply]
Re^2: Lightweight storage solution? by alexm (Chaplain) on Jul 24, 2008 at 17:39 UTC
Super Search shows a lot of recent references in several DB related questions. As for familiarity, dragonchild is the father :) Update: I'd give it a try, of course.	[reply]