News for hackers. Stuff that matters.

A comment on Design better databases. Parent comment

Re:Design better databases by dhd415 on Thursday April 07, 2016 @03:23PM (#11449883)
Every sequential GUID generation feature provides guarantees only per session. In other words, when you bring your database down to upgrade or patch it and then bring it back up, your GUID sequence starts over again at some arbitrary value which is likely to overlap with your existing GUIDs.
[ Parent | on HN ]
Re:Design better databases by gnaritas on Thursday April 07, 2016 @04:12PM (#11450258)
> your GUID sequence starts over again at some arbitrary value which is likely to overlap with your existing GUIDs.

I don't believe that's true. You're right that they start the session over, but it'll still be a fresh sequence that doesn't overlap anything generated in the past.

[ Parent | on HN ]