Using sqlite problem

[dadinugroho]

Hi cornernote,

Since this is a bit move from the archive issue, I decide to open a new issue.

How to use sqlite instead of mysql? Is that only by comment out the 'connectionId' ?

Is there any specific things that make you store the file in runtime? I see someone using protected/data to store a file, when not using database. See yii auth module. I understand that this may be a personal interest but I just want to know whether any other reason for this.

Thanks so much.

Daniel

[cornernote]

Hi @dadinugroho,

First you need to create a database connection in your config/main.php, under the components section. It may look like this:

return array(
    'components' => array(
        'dbAudit' => array(
            'class' => 'CDbConnection',
            'connectionString' => 'sqlite:/path/to/audit.db',
        ),
    ),
),

More info on setting up db connections can be found here: http://www.yiiframework.com/doc/blog/1.1/en/prototype.database

Next you need to set 'connectionID'='dbAudit'.

If you don't define a connectionID, then AuditModule will put its own database in the runtime folder. This is not recommended for production, it's more of a "lets just run out of the box with no config" type thing.