Unsigned Integers vs UUIDs for Laravel Distributed Systems

preview_player
Показать описание
Laravel Edition. In this quick tutorial I explain why using unsigned AUTO_INCREMENTED integer IDs for your database tables is bad and why you should use UUIDs instead. Using Laravel, I will show you how to do that quickly.
  1. Emad Zaamout
Рекомендации по теме
Unsigned Integers vs 0:08:12

Unsigned Integers vs UUIDs for Laravel Distributed Systems

C++ : UUID 0:01:29

C++ : UUID into unsigned int

The New ID 0:08:54

The New ID To Replace GUIDs and Integers in .NET

When To Use 0:46:35

When To Use UUIDs | Rubber Duck Dev Show 15

UUID in Kotlin 0:04:34

UUID in Kotlin Multiplatform

How to solve 0:06:15

How to solve MySQL UUID Performance Issues

Is there any 0:06:34

Is there any difference between a GUID and a UUID?

Creating UUIDs with 0:08:59

Creating UUIDs with JavaScript in Node & Browsers

Adventures in Shellcode 0:11:58

Adventures in Shellcode Obfuscation: Part 8 'Shellcode as UUIDs'

Databases: Should I 0:04:27

Databases: Should I use UUID as well as ID (3 Solutions!!)

Epi-57 UUID vs 0:04:14

Epi-57 UUID vs UUID(short) || Mysqli in Tamil

How could you 0:04:06

How could you make this UUID generator more efficient? [closed]

Rust Series Episode 0:25:08

Rust Series Episode - 13 | Structs | When to use? | UUID

Java.util.UUID Class Explained: 0:02:32

Java.util.UUID Class Explained: Introduction and Overview

Find the size 0:00:14

Find the size of integer in python

Unique ID Generator 0:12:44

Unique ID Generator System Design EXPLAINED | Ace your System Design Interview Playlist - Gourav

A const int 0:09:16

A const int is not a constant.

UUID in mysql 0:02:10

UUID in mysql database

MySQL 8 - 0:01:48

MySQL 8 - Demo UUID

The Most Useless 0:10:26

The Most Useless Keyword in C?

C#'s Enum performance 0:09:54

C#'s Enum performance trap your code is suffering from

Clarifying about literals, 0:13:14

Clarifying about literals, macros, and const (still not constant?)

Generate GUID - 0:12:11

Generate GUID - Java, PHP, Flutter

MySQL Indexes and 0:30:22

MySQL Indexes and Histograms to Speed Up Your Queries by Dave Stokes

Комментарии
Автор

You should now recommend UUID v7 instead of v4. v4 drawback is that its random and hence makes db indexes slow whereas v7 is lexicographically sortable, because it encodes a timestamp when generating a uuid, so its the new recommended version to keep your db indexes happy. Laravel already has HasVersion7Uuids trait implemented since some time now. Also you don't need to mark a primary key unique because primary key index already implies uniqueness, no need to separately create another index.

SiddharthPant