ulid-mssql

Implementation of ULID generator For Microsoft SQL Server (by rmalayter)

Ulid-mssql Alternatives

Similar projects and alternatives to ulid-mssql

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better ulid-mssql alternative or higher similarity.

ulid-mssql reviews and mentions

Posts with mentions or reviews of ulid-mssql. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-08-06.
  • New UUID Formats – IETF Draft
    11 projects | news.ycombinator.com | 6 Aug 2021
    Yeah, it's a small world.

    I actually took the opposite path and explored several of the micro-optimized ULID libraries in C# before settling down with NUlid which I decided had the cleanest API and documentation (and reasonably good response times to GitHub issues). The implementation of Cysharp's lib has a lot of Unsafe code, which I understand why they took that path (given the focus on Unity code), but I'm hesitant about it and I liked a lot better (conceptually) how much more Span code mcb2001's CSharp.Ulid library had and if I were to micro-optimize a library that's much more the path that I would take. (But so far micro-optimizations of that sort haven't been a priority in my real world usage and I'll take the well tested library with the nice API.) I created a couple simple extension methods to do the specific "ToSqlGuid()" and "ToUlidFromSql()" that I desired for the SQL Server sort order. (Which is just shuffling the first six bytes of a ULID byte array to the end of the GUID byte array and vice versa.)

    I actually trust that I can at least generate ULIDs in SQL Server, again because the part I care to be sorted/needs to be correct (the timestamp) fits into the non-endian-issue portion of a GUID in SQL Server. I've been using just the generator function from ulid-mssql [1] (I used it mostly just for DB migrations and it was nice to have for that). It was debugging the endian issues and Base-32 encoding issues of the "ULID GUID to string" functions where I gave up and decided I didn't trust doing that in database.

    [1] https://github.com/rmalayter/ulid-mssql

Stats

Basic ulid-mssql repo stats
1
39
4.2
4 months ago

rmalayter/ulid-mssql is an open source project licensed under Apache License 2.0 which is an OSI approved license.

The primary programming language of ulid-mssql is TSQL.


Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com