martinthenth
UUIDv7 - A UUID v7 implementation and Ecto.Type for Elixir - based on Rust
Hello everybody 
Recently, some of my colleagues talked about database ids and uuids and their problems, and I remembered the pain of working with randomly distributed primary keys. They’re nice at first but then you have to index and order by a different field like created_at, while serial and bigserial already have an order and are indexed as the primary key.
UUIDv6, UUIDv7 and UUIDv8 are new standards to deal with issues found in UUIDv4 and earlier. I especially liked this post that analyzes the new standards: https://blog.devgenius.io/analyzing-new-unique-identifier-formats-uuidv6-uuidv7-and-uuidv8-d6cc5cd7391a
My favourite is UUIDv7 because they’re like UUIDv4 but the first characters are based on a millisecond timestamp; it seems like a very small change.
Elixir doesn’t have a common implementation of UUIDv7 yet, and Ecto is based on UUIDv4. So I decided to build one based on a Rust package https://crates.io/crates/uuid, which is relatively mature.
The new library is called UUIDv7 and is available on Hex UUIDv7 - Hex.
Because it’s based on Rust, the UUID generation is a whopping 72% faster than the default Ecto.UUID version 4 generator. NIFs are precompiled and generated for most platforms.
It’s easy to set up, you only have to change one line:
def App.Schemas.User do
use Ecto.Schema
@primary_key {:id, UUIDv7, autogenerate: true}
end
You can verify the UUIDs are ordered by running a small test:
uuid1 = UUIDv7.generate()
uuid2 = UUIDv7.generate()
uuid3 = UUIDv7.generate()
uuid4 = UUIDv7.generate()
assert uuid1 < uuid2
assert uuid2 < uuid3
assert uuid3 < uuid4
Though you may have to add Process.sleep(1) between the generations to skip one millisecond (UUIDv7 is based on milliseconds and ends with random bits)
Since the performance difference between Rust-based UUID generation and Ecto.UUID is so large, maybe it could be a motivation to write other more commonly used functions as NIFs from more compute-efficient languages?
You can check the benchmark here: UUIDv7 - Benchmark
GitHub: UUIDv7 - GitHub
Hex: UUIDv7 - Hex
Most Liked
martinthenth
Yup, UUIDv7 and Uniq are compatible because of the shared standard, but uniq is a bit slower because it’s 100% Elixir. It’s comparable with Ecto.UUID.
iex(1)> UUIDv7.generate()
"0188f846-191e-7f32-81f1-871f64b71d6b"
iex(2)> Uniq.UUID.uuid7()
"0188f846-1ae4-7205-8cf4-ac0be8a620a1"
Benchmark:
Name ips average deviation median 99th %
uuidv7 1.75 M 570.22 ns ±3940.19% 500 ns 667 ns
uniq (uuid v7) 1.07 M 937.20 ns ±1852.78% 916 ns 1000 ns
ecto (uuid v4) 1.02 M 978.17 ns ±1593.54% 958 ns 1042 ns
Comparison:
uuidv7 1.75 M
uniq (uuid v7) 1.07 M - 1.64x slower +366.98 ns
ecto (uuid v4) 1.02 M - 1.72x slower +407.95 ns
sbuttgereit
New proposed standards. While it looks like UUID v6+ have made a lot of progress, they haven’t been adopted as standards yet: draft-ietf-uuidrev-rfc4122bis-14 - Universally Unique IDentifiers (UUID)
This isn’t to say that what ends up being adopted will be much different than has appeared in the various drafts, but for some the formality can matter.
As an aside, it looks like the scope of the proposed standard has expanded as they’ve progressed through the process to actually revising the UUID v1 through v5 standards as well: Revise Universally Unique Identifier Definitions (uuidrev)… the revisions to previous standards are very limited to doing things like correcting errata (unsurprisingly).
c4710n
A quote from https://uuid7.com/
- Concurrency and Distribution: In distributed systems, generating unique, sequential IDs can be a challenge. UUIDv7 can be generated concurrently across multiple nodes without the risk of collisions, making it suitable for distributed architectures.
LostKobrakai
uuid v5-v8 were accepted in May this year: RFC 9562: Universally Unique IDentifiers (UUIDs)
martinthenth
Thanks for the suggestion. You’re right that ecto is not required when using it without the Ecto.Type and I’ll add that to the roadmap for v1.0.0. When I find some time to work on that, I’ll also remove the dependency on rustler and make it a full Elixir-based UUID v7 generator. I’ll extend the testing suite to make sure it won’t break anything and remains fully compliant to the spec
Popular in Libraries
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"