#primary-keys on Hacker News

4 stories tagged primary-keys, newest first.

Screenshot of andyatkinson.com: Avoid UUID Version 4 Primary Keys in Postgres

Avoid UUID Version 4 Primary Keys in Postgres (andyatkinson.com)

336 points by pil0u 10 months ago | 370 comments

Blog post by Andrew Atkinson arguing against using random UUID version 4 values as primary keys in PostgreSQL, covering performance issues and alternatives.

postgresql uuid primary-keys database-performance

Screenshot of maciejwalkowiak.com: PostgreSQL and UUID as Primary Key

PostgreSQL and UUID as Primary Key (maciejwalkowiak.com)

387 points by taubek 2 years ago | 296 comments

A blog post by Maciej Walkowiak discussing the use of UUIDs as primary keys in PostgreSQL, including storage and performance considerations, with Java examples.

postgresql uuid primary-keys java

Screenshot of blog.ploeh.dk: You'll regret using natural keys

You'll regret using natural keys (blog.ploeh.dk)

660 points by thunderbong 2 years ago | 490 comments

Mark Seemann blog post arguing against using natural keys as database primary keys, illustrated with an anecdote about a car's incorrect chassis number.

natural-keys database-design surrogate-keys primary-keys