Laravel

Connect your laravel application to Sqlite DB

2019-10-02

Quickly connecting with sqlite database within laravel application

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,
],

As a developer, I always see the problem for creating images/banners whenever I post some content online.

Even for simple designs I always needed to open figma or search online, so I thought of automating it.

I've build BannerPot to solve this problem, would you like to give it a try?

Ramesh from BannerPot

Ramesh Mhetre

Maker of BannerPot