How To Use Laravel 8 SQLite Database using Windows
Tags: laravel, php, tutorial, mysql
Published: 2022-04-19 03:40:49

Originally posted @ https://codeanddeploy.com visit and download the sample code: https://codeanddeploy.com/blog/laravel/how-to-use-sqlite-database-in-laravel-8-using-windows

In this post, I will share how to use SQLite Database in Laravel 8. If your project is light and not a huge database then SQLite is suitable to use. It is an option also to use SQLite while developing locally. Now I will show it to you with an example. Just follow my few steps below on how to implement the Laravel SQLite database.

 

## First, Install Laravel 8.

Point to your htdocs directory and open your command prompt. Then run the following command:

```php
composer create-project laravel/laravel laravel-sqlite
```

Once installed run the next command to your command prompt.

```php
cd laravel-sqlite
```

## Second, Setup ENV for our SQLite Database

By default, you will see these lines inside the `.env file`.


```php
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=
```

Now, let's change it with the following lines below.

```php
DB_CONNECTION=sqlite
DB_HOST=127.0.0.1
DB_PORT=3306
```

As you can see we changed the DB_CONNECTION value to SQLite and removed DB_DATABASE, DB_USERNAME, DB_PASSWORD.

 

## Third, Create Laravel SQLite Database

Now lets, create our database inside your Laravel 8 directory project navigate to the following path: "project_folder/database" then create a file named "database.sqlite".


![how-to-use-sqlite-database-in-laravel-8-using-windows](https://ecn-storage.s3.us-west-2.amazonaws.com/articles/how-to-use-sqlite-database-in-laravel-8-using-windows-r9R2iQ3g4hx980.webp?ctm=1632915075)

## Fourth, Run Migration Command

Now, let's run the migration command.

```php
php artisan migrate
```

Once done your Laravel SQLite database is ready.

 

Now let's check application is working and if successfully connected with the SQLite database.

 

See below code from **routes/web.php.**

```php
<?php

use App\Models\User;
use Illuminate\Support\Facades\Route;

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('/', function () {

    User::updateOrCreate([
        'email' => 'jdoe@gmail.com'
    ],[
        'name' => 'John Doe',
        'email' => 'jdoe@gmail.com',
        'password' => bcrypt('password')
    ]);


    $users = User::all();

    print_r($users);
});
```

Then run the command:

```php
php artisan serve
```

Then run this to your browser: [http://127.0.0.1:8000/](http://127.0.0.1:8000/)


![how-to-use-sqlite-database-in-laravel-8-using-windows](https://ecn-storage.s3.us-west-2.amazonaws.com/articles/how-to-use-sqlite-database-in-laravel-8-using-windows-KneHM8sozdx980.webp?ctm=1632915255)

That's it you have successfully installed Laravel SQLite to your local server on windows. I hope this tutorial can help you. Kindly visit here https://codeanddeploy.com/blog/laravel/how-to-use-sqlite-database-in-laravel-8-using-windows if you want to download this code.

Happy coding :)