>
> Given a web context and a small dataset without mod_perl or other
> persistance scheme, the connection time when using an RDBMS will likely
> be as slow as the opening/parsing time of the flatfile. DB_file will
> only be quicker if your search terms are contained in the key column of
> the file and will be difficult to maintain/port because your queries
> won't be SQL. Using DBD::CSV or DBD::AnyData you can stick with SQL,
> have keys in any column and have 0 connection time.
Again I chime in too late on this, but this is a great way
to manage small datasets and still maintain a SQL paradigm.
I have succesfully used this technique to rapidly prototype
web-apps and to actually maintain DBs (1000+ records with 20+
fields, all in CVS flat file).
I also use this method as a front end to .htaccess password
file, so a local-area admin can add/delete users, as well as
change passwords.
I can't say enough good things about this module.
HTH
As Always
r
