Connect with Laravel

You can connect Laravel to SingleStore using the SingleStore Driver for Laravel ("the driver"). Refer to the SingleStore Driver for Laravel Github repository for its source code and related information.


  • Install PDO_MYSQL.

  • Install the driver via composer:

    composer require singlestoredb/singlestoredb-laravel

Connect to SingleStore

To connect Laravel to SingleStore, enable the driver and configure the connection.

To enable the driver, edit your config/database.php file and create a new entry for SingleStore in the connection configuration. Update the default option to point to the new connection or set DB_CONNECTION=singlestore in your environment file.

Here's a sample configuration:

'default' => env('DB_CONNECTION', 'singlestore'),
'connections' => [
'singlestore' => [
'driver' => 'singlestore',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST'),
'port' => env('DB_PORT'),
'database' => env('DB_DATABASE'),
'username' => env('DB_USERNAME'),
'password' => env('DB_PASSWORD'),
'unix_socket' => env('DB_SOCKET'),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
'options' => extension_loaded('pdo_mysql') ? array_filter([
]) : [],

The SingleStore driver is an extension of the MySQL driver, so you can also use the driver from mysql.

For more details, refer to the SingleStore Driver for Laravel and Laravel docs.

Last modified: June 11, 2024

Was this article helpful?