CODEWITHSUNDEEP
perl
KK99
KK99

Reputation: 1989

Light weight data store in Perl

My requirement is to maintain a simple data store with some rows (~1000) & columns (6)

Over period of time (2 years) I am expecting the data to grow to 1000-1500 lines/rows

I would like query, insert & update in the data store

I need this data store because this needs to be processed by another script.

I am using Perl for programming.

I have seen some threads in Stackoverflow (ex: looking for light-weight data persistence solution in perl) about this but I cannot make a decision

Anyone using light weight data store in Perl with query, insert & update capabilities ?

Upvotes: 2

Views: 188

Answers (4)

David W.
David W.

Reputation: 107040

Already accepted the answer, but in your case, I might just go with hashes and use Storable to write my structure to a disk. That is, if you don't have multiple people using the data at once.

The advantage is that it's all standard Perl, so it will work with almost any Perl installation. Can't get any lighter weight than this.

Upvotes: 4

Joel Berger
Joel Berger

Reputation: 20280

If your data is relational and you are comfortable with SQL then I vote DBD::SQLite.

However if your data is more like documents (each entry data is self contained) or if you are not comfortable with SQL then I recommend DBM::Deep. Its interface is exactly as easy to use as regular Perl variables.

Finally, if you want to be really modern, MongoDB is very easy to install and the new Mango Perl module is very cool, just saying :-)

Upvotes: 3

tobyink
tobyink

Reputation: 13664

Probably the simplest lightweight solution would be to use DBI with DBD::SQLite.

Upvotes: 3

Mandar Pande
Mandar Pande

Reputation: 12984

Go for Sqlite. It is powerful, tunable and lightweight.

Upvotes: 7

Related Questions