This post discusses using UUIDs as primary keys (but never exposing them), and an additional integer key on each table as the public facing ID. https://begriff

This post discusses using UUIDs as primary keys (but never exposing them), and an additional integer key on each table as the public facing ID. https://begriffs.com/posts/2018-01-01-sql-keys-in-depth.html https://begriffs.com/posts/2018-01-01-sql-keys-in-depth.html HN discussion: https://news.ycombinator.com/item?id=16050047 https://news.ycombinator.com/item?id=16050047