Has anyone out there tried DBD::Sprite? From the docs:
DBD::Sprite is similar to DBD::CSV, but differs in the following ways:
1) It creates and works on true "databases" with user-ids and
passwords,
2) The database author specifies the field delimiters, record
delimiters,
user, password, table file path, AND extension for each database.
3) Transactions (commits and rollbacks) are fully supported!
4) Autonumbering and user-defined functions are supported.
5) You don't need any other modules or databases. (NO prerequisites
except Perl 5 and the DBI module!
6) Quotes are not used around data.
7) It is not necessary to call the "$dbh->quote()" method all the
time
in your sql.
8) NULL is handled as an empty string.
9) Users can "register" their own data-conversion functions for use
in
sql. See "fn_register" method below.
The commit/rollback jumps out at me as being cool, since (AFAIK) DBD::CSV
doesn't do that (AutoCommit is always 1 I think).
Just saw this recently on the new modules mailing list but haven't had a
chance
to play with it - interested in hearing anything people have to say.
--
j.
James FitzGibbon voice/fax 612-761-6121/4277
Consultant, TTS-3D@TPN4H [EMAIL PROTECTED]
> -----Original Message-----
> From: Ron Hall [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 30, 2002 1:10 PM
> To: Jeff Zucker
> Cc: dbi-users
> Subject: Re: [Fwd: Which technique is faster?]
>
> 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.
