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
------------------------------------  -----
C84AC87F-842C-20EF-4D77-9F8429E95131  Visual Basic Programming
4AE8DEE4-501E-47EE-51A8-365AC5A069AC  Visual C++ Programming
60E22A73-8677-4630-B3CB-12131D16635C  VB .NET Programming
1515ED8C-823C-0166-8417-295981EA7158  C# .NET Programming
ED15158C-3C66-3F82-EE34-81295589EF43  Java Programming

as your database primary keys is the GUIDs will be unique across every table, every database and every server you have. This means you can easily merge records from different databases. Anyway, there is still a lot of pros and cons of using such 16-bytes GUIDs as discussed in..


But from now on, you have another option to choose for your database development.

Owh.. before I forget, as usual I'll offer great books for you to have. So, take a look at this reference manual... and enjoy!!

Comments

Post a Comment

Popular posts from this blog

How to Create Hyperlink on Blogger Post

-
Image
Well, this time I make a basic simple tutorial. For all advanced geek who read this blog, please ignore this post... I just wanna help myself not to teach the same basic thing on every newbies friends that really need help. OK guys, back to the howto... There are two ways to create a hyperlink on your blog post. One is the simple GUI way and the other is coders way. I prefer the coder way as I can have more control on it. I like to teach by example. So, let say you wanna create a hyperlink on this line of words... You can go here to see my art blog where you wanna link the word "here" to the other page on your blog or on the internet. In this example, I wanna link it to my Art Of Apogee Blog post with the address: http://artofapogee.blogspot.com/2008/03/gimp-best-free-photoshop.html And here is how to do it using both ways... The simple GUI way If you rollover every button on your Compose toolbar, you can see one button called "Link" where the word Link will pop u...
Read more

How to Add a Sudo User on AlmaLinux 9.2 (Turquoise Kodkod): A Step-by-Step Guide

-
Image
As a system administrator, one of the essential tasks in managing a Linux server is granting users administrative privileges through the "sudo" command. AlmaLinux, a robust and secure Linux distribution, follows the same principles as other CentOS/RHEL-based systems for managing users and permissions. In this tutorial, we'll walk you through the process of adding a sudo user on AlmaLinux 9.2.
Read more

How to Check AlmaLinux Version on the Command Line: A Quick Guide

-
Image
As a system administrator or a curious user, knowing the version of your operating system is crucial for troubleshooting, compatibility, and staying up-to-date with the latest features and security updates. AlmaLinux, a popular CentOS/RHEL-based Linux distribution, provides a straightforward method to check its version using the command line. In this tutorial, we'll walk you through the steps to check the AlmaLinux version on the command line.
Read more