Simple CockroachDB driver for Laravel 6+
You can install the package via composer:
composer require getghostr/cockroachdb-laravel
If you're not using package discovery please add the following to your providers array in config/app.php:
Ghostr\Cockroach\CockroachServiceProvider::class,Head over to your config/database.php and add the following to your connections array:
'cockroach' => [
'driver' => 'cockroach',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '5432'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'prefix' => '',
'prefix_indexes' => true,
'schema' => 'public',
'sslmode' => 'prefer',
],This package adds support for index stored columns
They can be declared in migrations like so:
Schema::table('my_table', function (Blueprint $table) {
// Single stored column
$table->index('col1')->storing('col2');
// Multiple stored columns
$table->index('col1')->storing(['col2', 'col3'])
})NOTE: Index name generation is unaffected by stored columns
Please see CHANGELOG for more information on what has changed recently.
Please see CONTRIBUTING for details.
The MIT License (MIT). Please see License File for more information.