Setting custom path for sqlite db in Laravel

Question

I want to use the sqlite db stored in "C:\Folder\my_database.sqlite" , what should i do? I want to use that sqlite db. Can anyone please suggest me a solution?

So i can give the path to sqlite in database.php below:

 'sqlite' => [
            'driver' => 'sqlite',
            'database' => "path to my sqlite db",
            'prefix' => '',
        ],

Also if that is done, then i can change my default connection to sqlite. Like:

DB::setDefaultConnection('sqlite');

Can anyone please suggest me a solution?

Not exactly sure what the problem is, but have you tried replacing "path to my sqlite db" with "C:\Folder\my_database.sqlite" in that code? — user8034901
– user8034901, Commented Jan 4, 2019 at 10:17
'database' => env('DB_DATABASE_LITE', "C:\Folder\my_database.sqlite"), Will this work? — Lano Angel
– Lano Angel, Commented Jan 4, 2019 at 10:20

taavs · Accepted Answer · 2019-01-04 10:20:52Z

4

As the Laravel Documentation states:

After creating a new SQLite database using a command such as touch database/database.sqlite, you can easily configure your environment variables to point to this newly created database by using the database's absolute path:

 'sqlite' => [
            'driver' => 'sqlite',
            'database' => "C:\Folder\my_database.sqlite",
            'prefix' => '',
        ],

To make it the default connection, just set this in your .env file:

DB_CONNECTION=sqlite

answered Jan 4, 2019 at 10:20

taavs

7299 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Md.Sukel Ali · Accepted Answer · 2019-01-04 10:22:47Z

2

Open your .env file and set,

DB_CONNECTION=sqlite
DB_DATABASE=C:\Folder\my_database.sqlite

further more information you can see: https://laravel.com/docs/5.7/database

answered Jan 4, 2019 at 10:22

Md.Sukel Ali

3,0655 gold badges26 silver badges36 bronze badges

Comments

Jignesh Joisar · Accepted Answer · 2019-01-04 10:35:19Z

1

for set sqlite database you can add absoulate path like this in database.php file..

'sqlite' => [
        'driver' => 'sqlite',
        'database' =>  'C:\Folder\my_database.sqlite',
        'prefix' => '',
],

for set a default sqlite connection update this in your .env file:

DB_CONNECTION=sqlite

for production update line(number 16) in database.php

'default' => env('DB_CONNECTION', 'sqlite'),

and then run this command in terminal for remove old configration and create new configration file.

php artisan config:cache

answered Jan 4, 2019 at 10:35

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

Collectives™ on Stack Overflow

Setting custom path for sqlite db in Laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related