database design

database design

Maybe Normalizing Isn't Normal

One of the items we're struggling with now on Stack Overflow is how to maintain near-instantaneous performance levels in a relational database as the amount of data increases. More specifically, how to scale our tagging system. Traditional database design principles tell you that well-designed databases are always normalized,

By Jeff Atwood ·
Comments

uuids

Primary Keys: IDs versus GUIDs

Long-time readers of this blog know that I have an inordinate fondness for GUIDs [https://blog.codinghorror.com/mastering-guids-with-occams-razor/]. Each globally unique ID [http://en.wikipedia.org/wiki/Globally_Unique_Identifier] is like a beautiful snowflake: every one a unique item waiting to be born. Perhaps that's why

By Jeff Atwood ·
Comments