DBD::CSV is a Perl database driver that uses flat text files
as the database. The default supports comma separated files, but that can
be customised in many ways, to support for example Unix password format
and Excel spreadsheet formats. DBD::CSV is available from CPAN. For more
information, see
Section 2.1.2. CPAN.
In DBSource, driver
name is "CSV", and a required option is f_dir, which specifies the
directory where the database files exist. DBUsername and DBAuth are not
required and are ignored.
DBD::CSV databases are flat text files.
The file name is the table name, for example,
subscribers
for the default AuthSelect. The first
line of a database file contains the names of the columns in the file. To
create a new database file, you need to create the text file with an
editor. A simple database file for subscribers that will work the default
AuthSelect in AuthBy SQL would be named subscribers
and it would look like this:
USERNAME,PASSWORD
mikem,fred
jim,jim
......
<more lines, one per user>
......
For DBD::CSV on Unix, configure your SQL clause like
this. DBUsername and DBAuth are not required. f_dir specifies the
directory where the database files are located. csv_eol in this example
specifies that the line separators are Unix newlines. You must have this
for a Unix style text file. You can leave it off to get Windows standard
text files.
DBSource dbi:CSV:f_dir=/your/data/dir;csv_eol=\012