UUIDNext
Ulid
UUIDNext | Ulid | |
---|---|---|
6 | 2 | |
157 | 842 | |
- | 5.5% | |
6.7 | 5.9 | |
13 days ago | 15 days ago | |
C# | C# | |
BSD Zero Clause License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
UUIDNext
-
Hey guys! Just wanted to share a tip on how to use performant Guid as primary keys in databases. Have you heard about UUID Version 7? It's here to save the day! Give it a try and let me know what you think. Happy coding! ππ»
Here's the link to the library: https://github.com/mareek/UUIDNext
-
I need some help to adapt my UUID/GUID library (UUIDNext) to generate the best UUIDs for PostgreSQL, MySQL and other DBMS
I maintain a library that generate database optimized UUIDs and to investigate how UUID are stored and sorted on various databases, I need you to execute a little program that show just that (see end of post for more details).
-
How to use performant Guid as primary keys in databases. UUID Version 7 to the rescue!
Not my library: UUIDNext
-
TL;DR HiLo Key Generation in Entity Framework
BUT if you want to us GUID's on the server side as performant indexes, use this: https://github.com/mareek/UUIDNext
- UUINext: a modern .NET library to generate database friendly or name based UUID/GUID based on the latest RFC draft [crosspost from r/csharp]
- UUINext: a modern .NET library to generate database friendly or name based UUID/GUID based on the latest RFC draft
Ulid
-
How to use performant Guid as primary keys in databases. UUID Version 7 to the rescue!
Side note, an interesting thing to add to your benchmarks would be ULID https://github.com/Cysharp/Ulid
-
New UUID Formats β IETF Draft
Iβm using Postgres so I actually have it a little easier with its native sort order. I switched from NUlid that I was using from years back to this one [0], and the default .ToGuid() gets the desired sort order when used with Npgsql. Likewise though, no db-side generation of uuid - then again, isnβt that the benefit of using globally unique identifiers in the first place, to avoid needing to rely on the db to generate conflict-free identifiers, skipping HiLo or sequences, etc.
Anyway, nice to meet another .NET Ulid user in the wild!
0: https://github.com/Cysharp/Ulid
What are some alternatives?
NewId - A sequential id generator that works across nodes with no collisions
uuid6-ietf-draft - Next Generation UUID Formats
uuid - Go package for UUIDs based on RFC 4122 and DCE 1.1: Authentication and Security Services.
ksuid - K-Sortable Globally Unique IDs
unity-guid-regenerator - :id: GUID regenerator for Unity assets
ulid-mssql - Implementation of ULID generator For Microsoft SQL Server
go.uuid - UUID package for Go
uulid.go - ULID-UUID compatibility library for generating and parsing ULIDs.
Huid - π« High-speed a FNV-1a-128 hash-based UUID.
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
rfc4122bis - revision to RFC4122
shortuuid.rb - Convert UUIDs & numbers into space efficient and URL-safe Base62 strings, or any other alphabet.