DBD::SQLite is a lightweight integrated SQL library that keeps
its database in a single flat file. It does not use a separate SQL server:
all the SQL functions are embedded in the SQLite library. DBD::SQLite is
available from CPAN. For more information, see
Section 2.1.2. CPAN.
In DBSource, driver
name is “SQLite”, and a required option is dbname
,
which specifies the path name of the single file where the database is to
be stored. It can be an absolute file path or a relative path. DBUsername
and DBAuth are not required and are ignored.
To create a new database,
see
goodies/postgres-sqliteCreate.sql
for more
information.
Configure your SQL clause like this. DBUsername and DBAuth
are not required:
DBSource dbi:SQLite:dbname=/path/to/your/dbfile