ksuid
cuid
Our great sponsors
ksuid | cuid | |
---|---|---|
38 | 8 | |
4,679 | 3,338 | |
2.2% | 1.1% | |
3.1 | 2.8 | |
7 months ago | 5 days ago | |
Go | JavaScript | |
MIT License | GNU General Public License v3.0 or later |
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.
ksuid
- What happens after 100 years?
-
Zero Downtime Postgres Upgrades
OP here - we avoid sequences in all but one part of our application due to a dependency. We use [KSUIDs][1] and UUID v4 in various places. This one "gotcha" applies to any sequence, so it's worth calling out as general advice when running a migration like this.
[1]: https://segment.com/blog/a-brief-history-of-the-uuid/
-
Bye Sequence, Hello UUIDv7
UUID v4 isn't large enough to prevent collisions, that is why segment.io created https://github.com/segmentio/ksuid which is 160bit vs the 128bit of a UUIDv4.
- You Don't Need UUID
- A Brief History of the UUID
-
Type-safe, K-sortable, globally unique identifier inspired by Stripe IDs
Assuming you don't need to use UUIDv7 (or any UUID's) then https://github.com/segmentio/ksuid provides a much bigger keyspace. You could just append a string prefix if you wanted to namespace, but the chance of collisions of a KSUID is many times smaller than a UUID of any version.
-
Unexpected downsides of UUID keys in PostgreSQL
KSUID's are have temporal-lexicographical order plus 128 bits of entropy, which is more than UUIDv4.
https://github.com/segmentio/ksuid
-
UUIDs are so much better than autoincrementing ids and it's not even close
That's why you use ksuid (https://segment.com/blog/a-brief-history-of-the-uuid/) or, if you're willing to go with a draft spec you could go with the new UUID formats https://www.ietf.org/archive/id/draft-ietf-uuidrev-rfc4122bi...
-
What Happened to UUIDv2?
Interesting in more history of UUIDs? Twilio Segment's blog has an amazing history lesson about how they came to be.
-
Which UUID package do you use? and why?
I use the ksuid from segment. https://github.com/segmentio/ksuid
cuid
-
Extracting Timestamp From CUID (Snowflake ❄️)
Not sure if this is the same, but a cuid related project had this requested a feature https://github.com/paralleldrive/cuid/issues/63
-
The best UUID type for a database Primary Key
I like this ones https://github.com/paralleldrive/cuid
-
Using a GUID vs. AutoIncrement number for primary key in Data Warehouse?
What about something like cuid? https://github.com/ericelliott/cuid
-
UUID/GUID, CUID & NanoID: What's The Difference?
CUID aims to solve the exact problem we discussed above with UUIDs. Quoted from CUID's GitHub:
- ROUBARAM UMA AARTE MINHA PRA FAZER NFT DE MAMACO! ÓDIO E NOJO DE CRYPTO!
- PostgreSQL UUID vs. Serial vs. Identity
- Collision-resistant ids optimized for horizontal scaling and performance
-
Things You Should Do Now
How does it compare to cuid [1]? If you know the differences, can you please explain them for those like me who do not know both?
[1] https://github.com/ericelliott/cuid
What are some alternatives?
ulid - Universally Unique Lexicographically Sortable Identifier (ULID) in Python 3
UUID - :snowflake: A PHP library for generating universally unique identifiers (UUIDs).
pg-ulid - ULID Functions for PostgreSQL
nanoid - A tiny (124 bytes), secure, URL-friendly, unique string ID generator for JavaScript
Dapper - Dapper - a simple object mapper for .Net
ulid-mssql - Implementation of ULID generator For Microsoft SQL Server
spec - The canonical spec for ulid
python-ksuid - A pure-Python KSUID implementation
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
uuid7 - UUID version 7, which are time-sortable (following the Peabody RFC4122 draft)
Optimus - 🤖 Id obfuscation based on Knuth's multiplicative hashing method for PHP.