Engineering Blog
Deep dives into unique identifiers, database performance, and the real-world trade-offs of building distributed systems. From UUID internals to the migrations, benchmarks, and outages they've caused in production — this is where we write up what we've learned.
- Why Switch From Auto-Increment IDs to UUIDs (and What Might Break)
- The Great Index Fragmentation Debate: Do UUIDs Really Kill Performance?
- Benchmark: UUID vs BIGINT Insert/Query Speed
- How Big Tech Generates Unique IDs at Scale (Twitter Snowflake, Instagram)
- 5 Real-World Bugs Caused by Bad UUID Implementations
- Migrating a Legacy Database From Integer IDs to UUIDs: A Case Study
- What's New in RFC 9562: UUID v6, v7, and v8 Explained
- NanoID: Why Some Developers Are Ditching UUIDs for Shorter IDs
- Common UUID Mistakes Developers Make (and How to Avoid Them)
- UUID Collision Stories: When Astronomically Unlikely Still Happens