UUID/GUID as primary keys in databases; generating them from a .NET assembly
Posted by jpluimers on 2021/04/08
Some links for my archive:
- [WayBack] postgresql – Does Postgres offer a feature like “NEWSEQUENTIALID” in MS SQL Server to make UUID as primary key more efficient – Database Administrators Stack Exchange
- [WayBack] c# – Is there a .NET equalent to SQL Servers newsequentialid() – Stack Overflow
- [WayBack] The Cost of GUIDs as Primary Keys | Natural or Surrogate Keys
- [WayBack] GitHub – phatboyg/NewId: A sequential id generator that works across nodes with no collisions
- [WayBack] nhibernate-core/GuidCombGenerator.cs at master · nhibernate/nhibernate-core · GitHub
- [WayBack] pinvoke.net: UuidCreateSequential (rpcrt4)
- The Type 1 UUIDs created by UuidCreateSequential don’t sort in SQL Server.SQL Server’s NewSequentialID uses UuidCreateSequential, with some byte shuffling applied.
- [WayBack] How to Generate Sequential GUIDs for SQL Server in .NET – David Browne’s Web Log
- [WayBack] “Version 6” UUIDs:UUID ‘Version 6’ is an alternate format which sorts correctly as raw bytes and is suitable for use as a primary key value in a database.
- [WayBack] If you want sequential IDs with no chance of collisions, read up on “flake” IDs … | Hacker News
- [WayBack] c# – Sequential GUIDs – Stack Overflow
- [WayBack] sql server – What are the best practices for using a GUID as a primary key, specifically regarding performance? – Stack Overflow
- [WayBack] database – UUID Primary Key in Postgres, What Insert Performance Impact? – Stack Overflow
–jeroen
Leave a Comment