Beginning Laravel: A beginner's guide to application development with Laravel 5.3

© Sanjib Sinha 2017

Sanjib Sinha, Beginning Laravel, 10.1007/978-1-4842-2538-7_11

11. SQLite Is a Breeze!

Sanjib Sinha¹ 

(1)Howrah, West Bengal, India

We’d like to make this application entirely based on SQLite database . Normally, for a big application people opt for MySQL or PgSQL as it can tackle more visitors. SQLite may not be big enough and basically file based and light in nature, but it can easily tackle small to medium applications with a hundred thousand visitors. So we can feel free to use it for our CRUD application. Especially for Laravel, SQLite is a breeze to use. In a minute you’ll understand why I sound so confident.

To use SQLite in Laravel you need to change the default database setup. Two lines need to be changed.

//Code/test/blog/config/databse.php ...