Lumen makes connecting with databases and running queries extremely simple. Currently Lumen supports four database systems: MySQL, Postgres, SQLite, and SQL Server.
You may use the
DB_* configuration options in your
.env configuration file to configure your database settings, such as the driver, host, username, and password.
Note: In order for your configuration values to be loaded, you will need to uncomment the
Dotenv::load()method call in your
Note: If you would like to use the
DBfacade, you should uncomment the
$app->withFacades()call in your
For example, without facades enabled, you may access a database connection via the
$results = app('db')->select("SELECT * FROM users");
Or, with facades enabled, you may access the database connection via the
$results = DB::select("SELECT * FROM users");
To learn how to execute basic, raw SQL queries via the database component, you may consult the full Laravel documentation.
Lumen may also utilize the Laravel fluent query builder. To learn more about this feature, consult the full Laravel documentation.
If you would like to use the Eloquent ORM, you should uncomment the
$app->withEloquent() call in your
Of course, you may easily use the full Eloquent ORM with Lumen. To learn how to use Eloquent, check out the full Laravel documentation.
For further information on how to create database tables and run migrations, check out the Laravel documentation on the migrations.