btw Ecto version 3.14 is out and has UUIDv7 support!
#elixirlang
#elixirlang
May 22, 2026 at 7:31 PM
btw Ecto version 3.14 is out and has UUIDv7 support!
#elixirlang
#elixirlang
UUIDv7 library v0.6.0 released for #elixirlang
Updated to use increased clock precision instead of a randomly-seeded counter, to match implementation merged into Postgres.
github.com/ryanwinchest...
Updated to use increased clock precision instead of a randomly-seeded counter, to match implementation merged into Postgres.
github.com/ryanwinchest...
GitHub - ryanwinchester/uuidv7: UUIDv7 for Elixir (and Ecto)
UUIDv7 for Elixir (and Ecto). Contribute to ryanwinchester/uuidv7 development by creating an account on GitHub.
github.com
February 27, 2025 at 9:42 PM
UUIDv7 library v0.6.0 released for #elixirlang
Updated to use increased clock precision instead of a randomly-seeded counter, to match implementation merged into Postgres.
github.com/ryanwinchest...
Updated to use increased clock precision instead of a randomly-seeded counter, to match implementation merged into Postgres.
github.com/ryanwinchest...
starting a single-issue advocacy PAC for issuing every american a UUIDv7
I have a number of hobby horses but one of them is “name matching sucks” and if you disagree it’s because you’ve never tried to use names as an identifier
Birthdate and name matches are causing US Citizens to get arrested in error by ICE as they board airplanes.
This is the same level of rigor they're bringing to claims of fraudulent voting, and is obvious as an error-prone method to anyone who has taken an introductory stats class.
This is the same level of rigor they're bringing to claims of fraudulent voting, and is obvious as an error-prone method to anyone who has taken an introductory stats class.
August 11, 2026 at 9:03 PM
starting a single-issue advocacy PAC for issuing every american a UUIDv7
🚨 New blog alert:
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
May 20, 2025 at 4:54 PM
🚨 New blog alert:
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
good news i am no longer running into oauth jti error maybe using uuidv7 for jti did it
January 3, 2025 at 4:40 AM
good news i am no longer running into oauth jti error maybe using uuidv7 for jti did it
PostgreSQL 18 is here 🎉 🐘
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
September 25, 2025 at 5:49 PM
PostgreSQL 18 is here 🎉 🐘
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
• Async I/O (io_uring/worker), faster reads
• More index hits (skip scan, OR)
• uuidv7(), virtual generated cols
• OAuth2;
Ask for Xata access and try PostgreSQL 18.
New short blog post, touching on how I'd redesign UUIDv7 to keep the database performance benefits while mitigating most of the downsides.
Short version: replace unix_ms with H(unix_ms, unix_ms >> 13 | salt).
Get yer extremely niche RFC commentary here: brooker.co.za/blog/2025/10...
Short version: replace unix_ms with H(unix_ms, unix_ms >> 13 | salt).
Get yer extremely niche RFC commentary here: brooker.co.za/blog/2025/10...
Fixing UUIDv7 (for database use-cases) - Marc's Blog
brooker.co.za
October 22, 2025 at 11:21 PM
New short blog post, touching on how I'd redesign UUIDv7 to keep the database performance benefits while mitigating most of the downsides.
Short version: replace unix_ms with H(unix_ms, unix_ms >> 13 | salt).
Get yer extremely niche RFC commentary here: brooker.co.za/blog/2025/10...
Short version: replace unix_ms with H(unix_ms, unix_ms >> 13 | salt).
Get yer extremely niche RFC commentary here: brooker.co.za/blog/2025/10...
Did you know that UUIDv7 is also supported by Python 3.14?
I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.
UUIDv7 is almost a no brainer for new proje... https://kjaymiller.com/microblog/202510130840.html
I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.
UUIDv7 is almost a no brainer for new proje... https://kjaymiller.com/microblog/202510130840.html
October 13, 2025 at 12:46 PM
Did you know that UUIDv7 is also supported by Python 3.14?
I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.
UUIDv7 is almost a no brainer for new proje... https://kjaymiller.com/microblog/202510130840.html
I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.
UUIDv7 is almost a no brainer for new proje... https://kjaymiller.com/microblog/202510130840.html
Ran into a nice surprise while looking at Postgres' UUIDv7 patch, which is that it guarantees monotonic incrementation on a per-backend basis.
Last writing of 2024: UUIDv7 monotonicity, how it works, and why it's great for writing tests. Happy NY!
brandur.org/fragments/uu...
Last writing of 2024: UUIDv7 monotonicity, how it works, and why it's great for writing tests. Happy NY!
brandur.org/fragments/uu...
Postgres UUIDv7 + per-backend monotonicity
How Postgres’ v7 UUIDs are made monotonic, and why that’s a great feature.
brandur.org
December 31, 2024 at 11:55 PM
Ran into a nice surprise while looking at Postgres' UUIDv7 patch, which is that it guarantees monotonic incrementation on a per-backend basis.
Last writing of 2024: UUIDv7 monotonicity, how it works, and why it's great for writing tests. Happy NY!
brandur.org/fragments/uu...
Last writing of 2024: UUIDv7 monotonicity, how it works, and why it's great for writing tests. Happy NY!
brandur.org/fragments/uu...
Você só precisa se duas colunas: ID (UUIDv7) e DATA (jsonb)
Nada como criar uma coluna JSONB no potgresql e meter tudo lá dentro... se um dia precisar vc cria uma tabela separada e faz um script de migration.
P.S.: Eu fiz isso recentemente, não me orgulho, mas "deu certo".
P.S.: Eu fiz isso recentemente, não me orgulho, mas "deu certo".
October 9, 2025 at 3:20 PM
Você só precisa se duas colunas: ID (UUIDv7) e DATA (jsonb)
ON THE OTHER HAND, being able to make REST requests, with the server doing live-transcoding of data to JSON (the devices don't know REST/JSON), so you can make curl requests against your embedded devices (including historical data), without knowing the schema as a consumer, is EXTREMELY cool:
![Terminal screenshot:
curl 'http://localhost:4444/api/devices/CA9FF06E058FF9A6/topics?path=simulator/temperature&key=583A352440D70716&count=3' -H "Accept: application/json" 2>/dev/null | jq
[
{
"uuidv7": "01938706-d74e-7dd3-9ebe-950bcc98c0eb",
"msg": {
"temp": 32625.43970753
}
},
{
"uuidv7": "01938706-d941-70c3-b71a-075df5e499bc",
"msg": {
"temp": 32628.581300183592
}
},
{
"uuidv7": "01938706-db35-7b11-88f8-9db7cad6bfa2",
"msg": {
"temp": 32631.72289283718
}
}
]](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:rqm4qgf6jdmb35mxatuzi6cq/bafkreih465bdqorognfa6vrzakqzu5unxr7ttmucvelp75x53gld6udvme)
December 2, 2024 at 4:23 PM
ON THE OTHER HAND, being able to make REST requests, with the server doing live-transcoding of data to JSON (the devices don't know REST/JSON), so you can make curl requests against your embedded devices (including historical data), without knowing the schema as a consumer, is EXTREMELY cool:
Postgres UUIDv7 + per-backend monotonicity brandur.org/fragments/uu...
Postgres UUIDv7 + per-backend monotonicity
How Postgres’ v7 UUIDs are made monotonic, and why that’s a great feature.
brandur.org
January 4, 2025 at 8:03 PM
Postgres UUIDv7 + per-backend monotonicity brandur.org/fragments/uu...
Anyone smart want to code-review my update to UUIDv7 library for #elixirlang?
I've redone it to match the updates to the Postgres implementation.
PR here: github.com/ryanwinchest...
Links to the two relevant files in thread
I've redone it to match the updates to the Postgres implementation.
PR here: github.com/ryanwinchest...
Links to the two relevant files in thread
Update to match changes in Postgres implementation by ryanwinchester · Pull Request #13 · ryanwinchester/uuidv7
Postgres has changed their implementation from CommitFest to the code that is actually committed to their repo.
This library is intended to always match Postgres's implementation.
See: https://...
github.com
February 27, 2025 at 2:29 AM
Anyone smart want to code-review my update to UUIDv7 library for #elixirlang?
I've redone it to match the updates to the Postgres implementation.
PR here: github.com/ryanwinchest...
Links to the two relevant files in thread
I've redone it to match the updates to the Postgres implementation.
PR here: github.com/ryanwinchest...
Links to the two relevant files in thread
I’ve just published a deep dive on UUIDv7 with Python 3.14, Django 5.2 and PostgreSQL 18 🐍
Covers Python uuidv7, Django db_default, PostgreSQL functions, GeneratedField and UUIDv47 as a safer alternative for public identifiers 🤖
👉 www.paulox.net/2025/11/14/h...
#Python #Django #PostgreSQL #UUIDv7
Covers Python uuidv7, Django db_default, PostgreSQL functions, GeneratedField and UUIDv47 as a safer alternative for public identifiers 🤖
👉 www.paulox.net/2025/11/14/h...
#Python #Django #PostgreSQL #UUIDv7
How to use UUIDv7 in Python, Django and PostgreSQL
Learn how to use UUIDv7 today with stable releases of Python 3.14, Django 5.2 and PostgreSQL 18. A step by step guide showing how to generate UUIDv7 in Python, store them in Django models, use Postgre...
www.paulox.net
November 14, 2025 at 9:25 PM
I’ve just published a deep dive on UUIDv7 with Python 3.14, Django 5.2 and PostgreSQL 18 🐍
Covers Python uuidv7, Django db_default, PostgreSQL functions, GeneratedField and UUIDv47 as a safer alternative for public identifiers 🤖
👉 www.paulox.net/2025/11/14/h...
#Python #Django #PostgreSQL #UUIDv7
Covers Python uuidv7, Django db_default, PostgreSQL functions, GeneratedField and UUIDv47 as a safer alternative for public identifiers 🤖
👉 www.paulox.net/2025/11/14/h...
#Python #Django #PostgreSQL #UUIDv7
Postgres 18.0 was just released!
What does it mean for Oban? Glad you asked:
- Asynchronous I/O for improved scans
- Skip scans for multi-column B-Tree indexes
- Parallel builds of GIN indexes
- Improved vacuum strategy
- Many optimizer improvements
- Native UUIDv7 data type
What does it mean for Oban? Glad you asked:
- Asynchronous I/O for improved scans
- Skip scans for multi-column B-Tree indexes
- Parallel builds of GIN indexes
- Improved vacuum strategy
- Many optimizer improvements
- Native UUIDv7 data type
September 26, 2025 at 8:31 AM
Postgres 18.0 was just released!
What does it mean for Oban? Glad you asked:
- Asynchronous I/O for improved scans
- Skip scans for multi-column B-Tree indexes
- Parallel builds of GIN indexes
- Improved vacuum strategy
- Many optimizer improvements
- Native UUIDv7 data type
What does it mean for Oban? Glad you asked:
- Asynchronous I/O for improved scans
- Skip scans for multi-column B-Tree indexes
- Parallel builds of GIN indexes
- Improved vacuum strategy
- Many optimizer improvements
- Native UUIDv7 data type
Excited for what’s coming this year! 🚀
• PostgreSQL 18 with UUIDv7
• NitroJS v3 pushing the limits
• Nuxt 4 taking things to the next level
Big things ahead! 🔥
• PostgreSQL 18 with UUIDv7
• NitroJS v3 pushing the limits
• Nuxt 4 taking things to the next level
Big things ahead! 🔥
February 19, 2025 at 9:44 AM
Excited for what’s coming this year! 🚀
• PostgreSQL 18 with UUIDv7
• NitroJS v3 pushing the limits
• Nuxt 4 taking things to the next level
Big things ahead! 🔥
• PostgreSQL 18 with UUIDv7
• NitroJS v3 pushing the limits
• Nuxt 4 taking things to the next level
Big things ahead! 🔥
UUIDv7 is not universally better
September 25, 2025 at 8:59 PM
UUIDv7 is not universally better
There is an active proposal: github.com/golang/go/is...
proposal: crypto/rand: add UUIDv4 and UUIDv7 · Issue #76319 · golang/go
Proposal Details // UUIDv4 generates a RFC 9562 Version 4 UUID // using only random bytes in the format: // xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx. func UUIDv4() string // UUIDv7 generates a RFC 9562...
github.com
January 11, 2026 at 3:07 PM
There is an active proposal: github.com/golang/go/is...
UUID v7 is time sortable and a proper standard buildkite.com/resources/bl...
Goodbye to sequential integers, hello UUIDv7!
Exploring the tradeoffs of different database indexes; from sequential integers, randomly generated UUIDs, to time-based identifiers and the latest & greatest UUIDv7
buildkite.com
November 24, 2024 at 8:04 AM
UUID v7 is time sortable and a proper standard buildkite.com/resources/bl...
UUIDv7 is like IPv6 in that it is better in all respects, but people just can't be damned
September 25, 2025 at 8:51 PM
UUIDv7 is like IPv6 in that it is better in all respects, but people just can't be damned
If only you picked UUIDv7 instead of UUIDv4, then they'd be timestamp sortable
April 1, 2026 at 7:22 AM
If only you picked UUIDv7 instead of UUIDv4, then they'd be timestamp sortable
Postgres 18. uuidv7() applied as a new PK column default. Inserts at 2-10K calls/minute. Inserts total time dropped from 1 millisecond to around 50 microseconds, about ~20x faster. Thanks to Postgres developers for this work which enables PK index maintenance to be much more efficient!
July 30, 2026 at 11:59 PM
Postgres 18. uuidv7() applied as a new PK column default. Inserts at 2-10K calls/minute. Inserts total time dropped from 1 millisecond to around 50 microseconds, about ~20x faster. Thanks to Postgres developers for this work which enables PK index maintenance to be much more efficient!