Laravel 8 SQLite Database Connection Example

Hello Laravel devs,

In this Laravel SQLite database example tutorial, I will show you step by step that how to connect Laravel to sqlite. For Laravel SQLite setup, we have to change our .env file and update database connection from MySQL to SQLite.

So if you don't know how to connect SQLite database in Laravel, this example is for you. You need to follow some steps to complete your SQLite setup in the Laravel application. I will show you from the windows. Let's start the example tutorial of Laravel SQLite connection:

how-to-connect-sqlite-database-in-laravel

 

Step 1: Update .env

In this, we need to update .env file like below. Replace your previous code like below:

.env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=tutorial
DB_USERNAME=root
DB_PASSWORD=

 

Now remove all the above code and update it like below:

DB_CONNECTION=sqlite

 

Step 2: Create SQLite File

Now we have to create our SQLite database. Create this file in the following path database/database.sqlite and then run php artisan migrate. All are ok. you can test now.

 

Read also: What is Signed URL and How and When to Use It in Laravel

 

Hope it can help you.

 

Facebook Github
A web enthusiastic, a self-motivated full-stack software engineer from Dhaka, Bangladesh with experience in developing applications using Laravel , React and Vue js