Use UUID, Ulid, or nanoid as optional or primary key in Laravel.
composer require riipandi/laravel-optikeyThis package adds a very simple trait to automatically generate a UUID, Ulid, or nanoid for your Models.
First, you need to add an extra column in your migration. For example:
php artisan make:migration AddOptikeyToUsersTable// If using UUID for the key
$table->uuid('uid')->after('id')->unique()->index();
// If using nanoid or ulid for the key
$table->string('uid')->after('id')->unique()->index();Sample migration:
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddOptikeyToUsersTable extends Migration
{
public function up()
{
// Add uid column to users table
Schema::table('users', function (Blueprint $table) {
$table->string('uid', 26)->index()->after('id');
});
// Prefill uid column in users table
Schema::table('users', function (Blueprint $table) {
$results = DB::table('users')->select('id')->get();
foreach ($results as $result) {
$ulid = \Ulid\Ulid::generate($lowercase = true); // Generate new lowercase Ulid
$generated = 'user_'.$ulid; // this is the generated value with optional prefix
DB::table('users')->where('id', $result->id)->update(['uid' => $generated]);
}
});
// Set uid column as unique
Schema::table('users', function (Blueprint $table) {
$table->unique('uid');
});
}
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('uid');
});
}
}Add the trait to your model (pick one between HasUuidKey, HasUlidKey, or HasNanoidKey):
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Riipandi\LaravelOptiKey\Traits\HasNanoidKey;
class User extends Model
{
use HasNanoidKey;
protected $optiKeyFieldName = 'uid'; // mandatory (you can change this field name)
protected $optiKeyLowerCase = true; // optional (default: false)
protected $optiKeyPrefix = 'user_'; // optional (default: null)
....
}Using scope:
\App\User::byOptiKey('xxxxxxxxxxx')->first();Or, using static find method:
\App\User::findByOptiKey('xxxxxxxxxxx');You need to change the primary key field type in your migration. For example:
$table->uuid('id')->primary(); // for UUID
$table->string('id', 26)->primary(); // for Ulid
$table->string('id', 16)->primary(); // for nanoidAdd second trait to use as primary key:
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Riipandi\LaravelOptiKey\Traits\HasUlidKey;
use Riipandi\LaravelOptiKey\Traits\OptiKeyAsPrimary;
class User extends Model
{
use HasUlidKey;
use OptiKeyAsPrimary;
protected $optiKeyFieldName = 'id';
...
}It simply tells Laravel that your primary key isn't an auto-incrementing integer, so it will treat the value correctly.
You can use prefix option to add a prefix to the generated key.
- Default lengt for Ulid is 26 characters.
- Default length for nanoid is 16 characters.
- If you want to use prefix, set larger length.
This project is licensed under MIT: https://aris.mit-license.org
Copyrights in this project are retained by their contributors. No copyright assignment is required to contribute to this project.
This package is Treeware. If you use it in production, then we ask that you buy the world a tree to thank us for our work. By contributing to the Treeware forest you’ll be creating employment for local families and restoring wildlife habitats.
Please see license file for more information.