TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

UUID vs. BIGSERIAL for Primary Keys

13 pointsby jaxonduover 9 years ago

1 comment

samchengover 9 years ago
Even if it is a hair slower, UUIDs (or similar schemes) are advantageous for reasons beyond being able to merge tables.<p>Another big advantage is being able to use the UUID as a key, without worrying about exploits from guessing serial numbers:<p><a href="https:&#x2F;&#x2F;en.wikipedia.org&#x2F;wiki&#x2F;Predictable_serial_number_attack" rel="nofollow">https:&#x2F;&#x2F;en.wikipedia.org&#x2F;wiki&#x2F;Predictable_serial_number_atta...</a>