Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Natural keys are often the best you can do if you're trying to be partition tolerant.

With surrogate keys you end up with duplicate entities whenever a partition heals (supposing the entity appeared to both partitions while they were still separate).



Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: