News for hackers. Stuff that matters.
Re:Design better databases by Smudge on Thursday April 07, 2016 @03:54PM (#11450120)
I don't disagree, but there is a case to be made for using UUID over sequential integer ids, and that is for horizontal scaling. When inserting records with UUID primary keys, you don't have to have your db cluster synchronized around which sequential ID should be next. There are other ways around this problem, of course, but using UUIDs sidesteps the issue entirely.
Re:Design better databases by mozumder on Thursday April 07, 2016 @04:06PM (#11450204)
Because a restaurant menu needs horizontal scaling...
Re:Design better databases by Smudge on Thursday April 07, 2016 @04:13PM (#11450264)
Any data might need horizontal scaling regardless of the type of content. It all comes down to how much data and how often it is accessed. So, sure, if you're building the website for a single restaurant, don't use UUIDs, because no matter how popular, it will never get that much traffic.