Hi there!

Configuration in laravel

Laravel is a powerful PHP framework that allows developers to build web applications with ease. One of the key features of Laravel is its ability to handle database interactions seamlessly. However, there may be scenarios where you want to run a Laravel project without a database, especially for testing or learning purposes. In this guide, we’ll walk you through the steps to set up and run a Laravel project without a database.

Why you get an error, if you run it as default?

When you try to run a Laravel project without a database, you might encounter errors related to database connections. This is because Laravel expects a database connection to be configured in the .env file. If the database connection is not set up correctly, you’ll see errors like “SQLSTATE[HY000] [2002] Connection refused” or similar messages.

The Fix: Change your Drivers!

While setting up a Laravel project, you can easily bypass the database requirement by changing the database driver in the .env file. Here’s how to do it:

1. Choose sqlite as your database, as you normally do. We will not use it, but it is required to run the project.
2. go to your database.php file located in config/database.php.
3. In the connections array, find the sqlite connection and set the database key to a file path that does not exist or is not used. For example:

'sqlite' => [
    'driver' => 'sqlite',
    'database' => database_path('database.sqlite'), // This file can be empty or not created
    'prefix' => '', 
],

4. But that alone won’t fix it, you will probably get an error like this:

Illuminate\Database\QueryException  : SQLSTATE[HY000]: General error: 1 no such table: users (SQL: select * from users where id = ?)

or

Illuminate\Database\QueryException  : could not find driver

to fix this, you need to go to session.php file located in config/session.php and change the driver to file or array:

'driver' => 'array',
|| 'driver' => 'file',

5. In your database.php file, you can also add a none option, for easy switching later:

'none' => [
    'driver' => 'sqlite',
    'database' => ':memory:',
    'prefix' => '',
],

6. Finally, just to make sure, change the drivers and connections in your .env file to match the changes you made in the config/database.php file:

DB_CONNECTION=none
DB_DATABASE=:memory:

SESSION_DRIVER=null
SESSION_DOMAIN=null

Now you can run your Laravel project without a database, and it should work without any issues. This setup is particularly useful for testing or when you want to focus on the application logic without worrying about database interactions.

Conclusion

Running a Laravel project without a database is straightforward by adjusting the configuration files. By setting the database driver to sqlite with a non-existent file and changing the session driver, you can avoid database-related errors and run your Laravel application smoothly. This approach is beneficial for beginners who want to learn Laravel without the complexities of database management. Happy laravelling!?