I'm trying to connect my application in Yii2 with a BD in Yii2 so far this is the configuration I have in my .db file
return [
'class' => 'yii\db\Connection',
'dsn' => 'sqlite:' . __DIR__ .'/../../softwareoperacional.db',
];
about your configuration file main.php or main-local.php
the configuration to be handled would be
return [
// ...
'components' => [
.....
'db' => [
'class' => 'yii\db\Connection',
'dsn' => 'sqlite:/miDB.db',
],
.....
],
];
the database file must have read and write permissions to perform necessary operations such as SELECT e INSERT , you can find more information in the following link link
Note that you must have the sqlite extension installed to work.