Database Development: GUIDs or IDs as Primary Key?
I got quite busy so I didn't have enough time to post in this blog. Currently, I'm coding for another monitoring system device that will work in parallel with my last visual basic development on vibration monitoring . Today, I'm dealing with MySQL database that will keep all the measurement data will be updated in real time. Something that I found on my reader today catch my interest where Jeff Atwood wrote about wether to use IDs or GUIDs for database primary keys. Before you're asking me. GUID or Globally Unique Identifier is a pseudo-random number used in software applications. The difference between normal IDs that usually in form of auto increment integer value... ID Value -- ----- 1 Visual Basic Programming 2 Visual C++ Programming 3 VB .NET Programming 4 C# .NET Programming 5 Java Programming and GUID keys which most commonly written in text as a sequence of hexadecimal digits... ID Value --------------------------...