Open in app
Home
Notifications
Lists
Stories

Write
Skurpi
Skurpi

Home

Dec 17, 2020

Database Primary Keys and UUIDs

A TL;DR; regarding exposing database keys — Use incrementing numbers for primary keys. Next to it, have a surrogate key that is a UUIDv4, and is generated on insert. The primary key increases performance for joins and internal workings in the database, while the surrogate key can be used externally to identify resources (users, payments, etc).

Database

2 min read

Database Primary Keys and UUIDs
Database Primary Keys and UUIDs

Dec 14, 2020

Master to Main with GitLab

New industry standard and #blm — Why To be honest, this article from Wired gives a good perspective on why you should or should not do this. Read it first. Read it? Good. Now if you still want to do this, here is a template that we followed for each of our GitLab repos. …

Git

4 min read

Master to Main with GitLab
Master to Main with GitLab
Skurpi

Skurpi

Following
  • Wil Wheaton

    Wil Wheaton

  • Medium

    Medium

  • Henric Trotzig

    Henric Trotzig

  • Spotify

    Spotify

  • Internet of Shit

    Internet of Shit

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Knowable