Hacker NewsDec 15

Avoid UUIDv4 Primary Keys

https://andyatkinson.com/avoid-uuid-version-4-primary-keys

#HackerNews #AvoidUUIDv4 #PrimaryKeys #DatabaseDesign #BestPractices #TechAdvice

Avoid UUID Version 4 Primary Keys

Introduction Over the last decade, when working on databases with UUID Version 41 as the primary key data type, these databases have usually have bad performance and excessive IO. https://datatracker.ietf.org/doc/html/rfc4122#section-4.4 ↩

Software Engineer, Author, High Performance PostgreSQL for Rails
Joche OjedaJan 22

Hard to Kill: Why Auto-Increment Primary Keys Can Make Data Sync Die Harder

https://www.jocheojeda.com/2025/01/22/hard-to-kill-why-auto-increment-primary-keys-can-make-data-sync-die-harder/

#database #dataSynchronization #primaryKeys #guid #sqlServer #mysql #postgresql #oracle #autoIncrement #databaseDesign #distributedSystems #entityFramework #xpo #identityColumns #sequences #databaseArchitecture #dataIntegrity #databasePerformance #uniqueIdentifiers #systemDesign

Hard to Kill: Why Auto-Increment Primary Keys Can Make Data Sync Die Harder | Joche Ojeda