Re^4: SQLite performance


Perl-Sensitive Sunglasses
	PerlMonks

Re^4: SQLite performance

by DrHyde (Prior)

on May 02, 2007 at 10:04 UTC ( [id://613146]=note: print w/replies, xml )

Need Help??

in reply to Re^3: Perl solution for storage of large number of small files
in thread Perl solution for storage of large number of small files

SQLite is a "database of last resort". It's good for prototyping, and for bundling with applications cos it requires no setup, but most of the time I'd prefer to use PostgreSQL, MySQL or a "grown-up" database like Oracle.

Implementing your own primitive bucketing algorithm by using several DBM files sounds ... perverse. If going down the DBM route, I'd use just one file and let perl handle that. I'd also use GDBM_File in preference to DB_File as it has fewer restrictions on your data. You might want to consider DBM::Deep if you want to fake up a filesystem in a file, or go crazy and create a *real* filesystem in a file, optimised for your circumstances, and mount that.

Comment on Re^4: SQLite performance

Replies are listed 'Best First'.

Re^5: SQLite performance
by jbert (Priest) on May 02, 2007 at 10:52 UTC

Using sqlite in a solution simplifies the solution compared to server-based RDBMSs (fewer moving parts and fewer deployment/management issues) and so reduces the costs and time spent dealing with it.

So unless you: