19.5. SQLite Previous topic Parent topic Child topic Next topic

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:
dbish -batch dbi:SQLite:dbname=/path/to/your/dbfile <goodies/sqliteCreate.sql
For DBD::SQLite, configure your SQL clause like this. DBUsername and DBAuth are not required.
DBSource    dbi:SQLite:dbname=/path/to/your/dbfile