How to connect sqLite to Yii2?

Question

Yii

There was a problem connecting the sqLite database to Yii2.
I looked at the documentation, but there is no clear connection example.
If someone has already connected sqLite to Yii2, please share your experience.
I'm interested in what you write in connection configuration

return [
    'class' => 'yii\db\Connection',
    'dsn' => 'sqlite:/config/db.sql',
    'username' => 'root',
    'password' => '',
    'charset' => 'utf8',
];

and the folder where you put the sqlite database.

Answer 1

$_fn=realpath(__DIR__."/../data")."/data.db";

return [
    'class' => 'yii\db\Connection',
    'dsn' => 'sqlite:'.$_fn,
];

the database is located in <site_root>/data/data.db
works on both IIS and LAMP