![Thumbnail of Stop using Integer ID’s in your Database](https://miro.medium.com/v2/resize:fit:592/1*Pwd8gQfYJNPu5hLDS0wGLQ.png)
updated 1y ago
updated 1y ago
The problem is that most companies don’t apply the required forethought to creating the right primary keys to allow data from different channels to be merged.
Alex Wittenberg added
Having a unique ID number for every object can come in handy when you’re trying to determine whether two objects are the same as each other.
Nicolay Gerold added
The current generation of designers have spent their careers learning how to work faster and faster and faster. And while there’s certainly something to be said for speed, excessive speed tends to blur one’s purpose. To get products through that gate before anyone noticed what they were and how foul they smelled. Because we broke some things.
... See moresari added
Alex Wittenberg added
A common workaround is to de-normalize the database so that queries that previously require joins can be performed on a single table.
This approach has typically lead to expensive, monster-sized databases that are not designed for a specific purpose and do not perform well.