Download the PHP package nbj/cockroachdb-laravel without Composer
On this page you can find all versions of the php package nbj/cockroachdb-laravel. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download nbj/cockroachdb-laravel
More information about nbj/cockroachdb-laravel
Files in nbj/cockroachdb-laravel
Package cockroachdb-laravel
Short Description CockroachDB driver for Laravel 8
License MIT
Informations about the package cockroachdb-laravel
cockroachdb-laravel
CockroachDB database driver for Laravel 8
Usage
Step 1: Install Through Composer
Step 2: Add the Service Provider (This happens automatically in Laravel 5.5)
Open config/app.php
and, to your "providers" array, add:
Step 3: Add Database Driver Configuration
Open config/datbase.php
and, to your "connections" array, add:
Make sure to update host, port, database, username, password and schema to your configuration. Note the database and schema fields should be the same.
Secure Mode
Update sslcert, sslkey and sslrootcert with your path configuration.
CockroachDB 2
Changes made to CockroachDB handles schemas slightly different when using the PHP Postgres driver. So instead of using:
We need to use the Postgres default of public
so change your config
to:
And everything should work as expected.
Known issues
- Constraints cannot be in the same migration as the creation of a table. The workaround is to add your constraints to its own migration after the table has been created.
Usage without laravel
It is entirely possible to use this driver without the entire Laravel framework.
Laravel's database components are neatly packaged in its own composer package
called illuminate/database
Simply require this package into your project, and
you are ready to go.
To set up a database connection you need to create a new Capsule
and register it.
It is even possible to use Eloquent (Laravel's ORM) if you choose to. Simply add:
By this point you are able to use the globally registered DatabaseManager like this: