如何使用我的Laravel项目配置我的SQLite数据库？

Question

I had created a database named Grocs.db using sqlite3 .The path of the database is C:\Sqlite\Grocs.db.

• How can I configure this Grocs.db database into my Laravel Project?

• Is it fine to simply move this database to the my laravel project's database folder? i.e. to the path mylaravelproject/database ?

• If it is done by the above method, then what about the extension .db? Should I have to change the extension from Grocs.db to Grocs.sqlite?

Answer 1

You can configure the database connection in the ./.env file of the application.

DB_CONNECTION=sqlite
DB_DATABASE=/absolute/path/to/database.sqlite

The Laravel database documentation contains the 'SQLite Configuration' section.