Connect your laravel application to Sqlite DB

Connect your laravel application to Sqlite DB

2019-08-02T16:57:26.000Z

I've come across this scenario of connecting to Sqlite database, mainly when quickly prototyping something with laravel.

As usual, its a quick thing with your laravel application. It is also mentioned in the official docs here.

Quick steps:

  • Create your DB file (yourdb.sqlite) file anywhere within your application. I prefer to create it in storage folder such as touch database/database.sqlite.
  • Change your .env file like:
DB_CONNECTION=sqlite
DB_DATABASE=/absolute/path/to/database.sqlite

To enable foreign key constraints for SQLite connections, you should add the foreign_key_constraints option to your config/database.php configuration file:

'sqlite' => [
    // ...
    'foreign_key_constraints' => true,
],