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:
Step 1: Update .env
In this, we need to update
.env file like below. Replace your previous code like below:
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:
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.
Hope it can help you.