#uuidv7 — Public Fediverse posts

@adamchainz @ngnpope @felixxm you can also have a generated field with the creation time extracted from the uuid which can be more efficient ;-)

https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/#adding-the-creation_time-generated-column

#Django #UUID #UUIDv7 #PostgreSQL

@adamchainz @ngnpope @felixxm you can also have a generated field with the creation time extracted from the uuid which can be more efficient ;-)

https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/#adding-the-creation_time-generated-column

#Django #UUID #UUIDv7 #PostgreSQL

@adamchainz @ngnpope @felixxm you can also have a generated field with the creation time extracted from the uuid which can be more efficient ;-)

https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/#adding-the-creation_time-generated-column

#Django #UUID #UUIDv7 #PostgreSQL

@adamchainz @ngnpope @felixxm you can also have a generated field with the creation time extracted from the uuid which can be more efficient ;-)

https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/#adding-the-creation_time-generated-column

#Django #UUID #UUIDv7 #PostgreSQL

@adamchainz @ngnpope @felixxm you can also have a generated field with the creation time extracted from the uuid which can be more efficient ;-)

https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/#adding-the-creation_time-generated-column

#Django #UUID #UUIDv7 #PostgreSQL

Another fucking year.

Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)

Thank you.

#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev

Another fucking year.

Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)

Thank you.

#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev

Another fucking year.

Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)

Thank you.

#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev

Another fucking year.

Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)

Thank you.

#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev

Another fucking year.

Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)

Thank you.

#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev

[Перевод] Опасности первичных ключей UUID в SQLite и оптимизация данных

В базах данных в качестве первичных ключей часто используют случайные UUID. Один из известных недостатков случайных UUID заключается в том, что их неупорядоченность (UUID4) может вызывать большое количество дополнительных обращений к страницам кластеризованных индексов (clustered index), потому что строки вставляются в случайные места B-дерева, и его приходится постоянно перебалансировать. В этой статье я попытаюсь помочь вам выработать более интуитивное понимание того, как влияют на производительность все эти дополнительные операции со страницами. Хотя статья посвящена конкретно SQLite, проблема случайных UUID касается и других баз данных, использующих кластеризованные индексы.

https://habr.com/ru/articles/1045870/

#первичные_ключи #uuidv4 #uuidv7

UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

https://www.youtube.com/watch?v=JbdvmQ_HgJo

#UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

https://www.youtube.com/watch?v=JbdvmQ_HgJo

#UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

https://www.youtube.com/watch?v=JbdvmQ_HgJo

#UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

https://www.youtube.com/watch?v=JbdvmQ_HgJo

#UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

https://www.youtube.com/watch?v=JbdvmQ_HgJo

#UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

📰 主キーはもう「UUIDv7」一択なのか？ 〜 ID技術の歴史的変遷と現時点の最適解 〜 (👍 68)

🇬🇧 Is UUIDv7 the only choice for primary keys? Historical evolution of ID technologies and current best practices explained.
🇰🇷 주키는 이제 UUIDv7 일택? ID 기술의 역사적 변천과 현시점의 최적해를 상세 분석.

🔗 https://zenn.dev/loglass/articles/c2db7e85702571

#UUIDv7 #Database #Zenn

How to use #UUIDv7 in #Python, #Django and #PostgreSQL https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

How to use #UUIDv7 in #Python, #Django and #PostgreSQL https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

[Перевод] Более глубокий взгляд на старый UUIDv4 и новый UUIDv7 в PostgreSQL 18

UUIDv4 как первичный ключ в PostgreSQL обычно ругают за «случайность» — но за этим словом прячется конкретная физика: сплиты страниц B-дерева, рыхлый листовой уровень, фрагментация и лишний случайный I/O при чтении. В PostgreSQL 18 появился UUIDv7 — и это хороший повод посмотреть на проблему не на уровне вкусов, а на уровне того, как реально устроены индекс и heap: от корреляции и ctid до статистики страниц и плотности листьев.

https://habr.com/ru/companies/otus/articles/979212/

#UUIDv4 #postgresql #UUIDv7 #PostgreSQL_18 #первичный_ключ #Btree_индекс #фрагментация_индекса #локальность_данных

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new How-to guide on installing PostgreSQL 18 on Ubuntu 25.10 (Questing Quokka). 🦫

Learn how to switch from the default PostgreSQL 17 to version 18 and try new features like UUIDv7 using the official PGDG repository: fast, clean, and developer-friendly setup. 🐘

https://www.paulox.net/2025/10/31/install-postgresql-18-on-ubuntu-25-10-questing-quokka/

CC @postgresql

#PostgreSQL #Ubuntu #Linux #Python #Django #UUID #UUID7 #UUIDv7

Just published a new How-to guide on installing PostgreSQL 18 on Ubuntu 25.10 (Questing Quokka). 🦫

Learn how to switch from the default PostgreSQL 17 to version 18 and try new features like UUIDv7 using the official PGDG repository: fast, clean, and developer-friendly setup. 🐘

https://www.paulox.net/2025/10/31/install-postgresql-18-on-ubuntu-25-10-questing-quokka/

CC @postgresql

#PostgreSQL #Ubuntu #Linux #Python #Django #UUID #UUID7 #UUIDv7

Just published a new How-to guide on installing PostgreSQL 18 on Ubuntu 25.10 (Questing Quokka). 🦫

Learn how to switch from the default PostgreSQL 17 to version 18 and try new features like UUIDv7 using the official PGDG repository: fast, clean, and developer-friendly setup. 🐘

https://www.paulox.net/2025/10/31/install-postgresql-18-on-ubuntu-25-10-questing-quokka/

CC @postgresql

#PostgreSQL #Ubuntu #Linux #Python #Django #UUID #UUID7 #UUIDv7

Just published a new How-to guide on installing PostgreSQL 18 on Ubuntu 25.10 (Questing Quokka). 🦫

Learn how to switch from the default PostgreSQL 17 to version 18 and try new features like UUIDv7 using the official PGDG repository: fast, clean, and developer-friendly setup. 🐘

https://www.paulox.net/2025/10/31/install-postgresql-18-on-ubuntu-25-10-questing-quokka/

CC @postgresql

#PostgreSQL #Ubuntu #Linux #Python #Django #UUID #UUID7 #UUIDv7

Just published a new How-to guide on installing PostgreSQL 18 on Ubuntu 25.10 (Questing Quokka). 🦫

Learn how to switch from the default PostgreSQL 17 to version 18 and try new features like UUIDv7 using the official PGDG repository: fast, clean, and developer-friendly setup. 🐘

https://www.paulox.net/2025/10/31/install-postgresql-18-on-ubuntu-25-10-questing-quokka/

CC @postgresql

#PostgreSQL #Ubuntu #Linux #Python #Django #UUID #UUID7 #UUIDv7

ULID, UUIDv4 и UUIDv7 в логах nginx: как сделать поиск по ID быстрым и удобным в ClickHouse

Когда вы работаете с распределённой системой — будь то микросервисы, фронтенд + бэкенд или nginx + приложение — жизненно важно иметь возможность «протянуть» один и тот же идентификатор запроса через все её компоненты. Это позволяет сопоставлять логи из разных источников, быстро находить ошибки и проводить корреляционный анализ. В nginx для этого из коробки есть переменная $request_id — 32-символьный hex-идентификатор (например, a1b2c3d4e5f678901234567890abcdef ). Его можно передать бэкенду через proxy_set_header X-Request-ID $request_id; или fastcgi_param HTTP_X_REQUEST_ID $request_id; , а также сохранить в access-логах. Однако стандартный $request_id — это просто случайная строка без временной привязки и без структуры, удобной для аналитики. В этой статье мы рассмотрим, как улучшить ситуацию с помощью ULID и UUIDv7.

https://habr.com/ru/articles/960266/

#clickhouse #nginx #uuid #uuidv7 #uuidv4 #ulid #logs

I'm getting back into blogging and trying my first collection. I got nerd sniped on a #uuid related topic and ended up doing lots of writing-as-thinking, which I'll slowly convert to blog posts. Here's the first installment: Why UUIDs won't protect your secrets. It covers #uuidv7 #idorvulnerability and some related concepts.

https://alexsci.com/blog/uuids-and-idor/

I'm getting back into blogging and trying my first collection. I got nerd sniped on a #uuid related topic and ended up doing lots of writing-as-thinking, which I'll slowly convert to blog posts. Here's the first installment: Why UUIDs won't protect your secrets. It covers #uuidv7 #idorvulnerability and some related concepts.

https://alexsci.com/blog/uuids-and-idor/

I'm getting back into blogging and trying my first collection. I got nerd sniped on a #uuid related topic and ended up doing lots of writing-as-thinking, which I'll slowly convert to blog posts. Here's the first installment: Why UUIDs won't protect your secrets. It covers #uuidv7 #idorvulnerability and some related concepts.

https://alexsci.com/blog/uuids-and-idor/

I'm getting back into blogging and trying my first collection. I got nerd sniped on a #uuid related topic and ended up doing lots of writing-as-thinking, which I'll slowly convert to blog posts. Here's the first installment: Why UUIDs won't protect your secrets. It covers #uuidv7 #idorvulnerability and some related concepts.

https://alexsci.com/blog/uuids-and-idor/

I'm getting back into blogging and trying my first collection. I got nerd sniped on a #uuid related topic and ended up doing lots of writing-as-thinking, which I'll slowly convert to blog posts. Here's the first installment: Why UUIDs won't protect your secrets. It covers #uuidv7 #idorvulnerability and some related concepts.

https://alexsci.com/blog/uuids-and-idor/

@carlton @kjaymiller @simon something like UUIDv47 can solve the UUIDv7 security related problem 💡

https://github.com/stateless-me/uuidv47

#UUIDv4 #UUIDv7 #UUIDv47 #Python #C #Rust #UUID

@carlton @kjaymiller @simon something like UUIDv47 can solve the UUIDv7 security related problem 💡

https://github.com/stateless-me/uuidv47

#UUIDv4 #UUIDv7 #UUIDv47 #Python #C #Rust #UUID

🐌💨 Look out world, #PostgreSQL 18 just discovered #UUIDv7, and we’re exploring it with the urgency of a crab on a zen retreat. Sure, Alexander and Jay might try to jazz it up with keynotes and baseball, but in reality, it's just another chapter of programmers pretending #UUIDs are the Rosetta Stone of #databases. ⚾🦀
https://aiven.io/blog/exploring-postgresql-18-new-uuidv7-support #CrabRetreat #ProgrammerHumor #HackerNews #ngated

🐌💨 Look out world, #PostgreSQL 18 just discovered #UUIDv7, and we’re exploring it with the urgency of a crab on a zen retreat. Sure, Alexander and Jay might try to jazz it up with keynotes and baseball, but in reality, it's just another chapter of programmers pretending #UUIDs are the Rosetta Stone of #databases. ⚾🦀
https://aiven.io/blog/exploring-postgresql-18-new-uuidv7-support #CrabRetreat #ProgrammerHumor #HackerNews #ngated

Exploring PostgreSQL 18's new UUIDv7 support

https://aiven.io/blog/exploring-postgresql-18-new-uuidv7-support

#HackerNews #PostgreSQL #UUIDv7 #UUIDs #DatabaseTech #PostgreSQL18 #AivenBlog

Exploring PostgreSQL 18's new UUIDv7 support

https://aiven.io/blog/exploring-postgresql-18-new-uuidv7-support

#HackerNews #PostgreSQL #UUIDv7 #UUIDs #DatabaseTech #PostgreSQL18 #AivenBlog

Oh snap. #Postgres v18 will support #UUIDv7! This is brilliant. Full filtering and sorting accessibility from the ID alone. 🤯 Truly can't wait. I been migrating all my ids to v7 already. I'm ready for the benefits. 😎

https://www.thenile.dev/blog/uuidv7

Oh snap. #Postgres v18 will support #UUIDv7! This is brilliant. Full filtering and sorting accessibility from the ID alone. 🤯 Truly can't wait. I been migrating all my ids to v7 already. I'm ready for the benefits. 😎

https://www.thenile.dev/blog/uuidv7

UUIDv47: Store UUIDv7 in DB, emit UUIDv4 outside (SipHash-masked timestamp)

https://github.com/stateless-me/uuidv47

#HackerNews #UUIDv47 #UUIDv7 #UUIDv4 #SipHash #Database

UUIDv47: Store UUIDv7 in DB, emit UUIDv4 outside (SipHash-masked timestamp)

https://github.com/stateless-me/uuidv47

#HackerNews #UUIDv47 #UUIDv7 #UUIDv4 #SipHash #Database

How come there's not a single cli in nixpkgs that can do UUIDv7?..

Actually; I don't even need a cli, there's elisp for that! https://antonz.org/uuidv7/#emacs-lisp

#uuidv7 #emacs

How come there's not a single cli in nixpkgs that can do UUIDv7?..

Actually; I don't even need a cli, there's elisp for that! https://antonz.org/uuidv7/#emacs-lisp

#uuidv7 #emacs

UUIDv7 — ключ к глобальному поиску с помощью LLM в произвольных внешних системах

Представим себе такой сценарий. Пользователь устно и/или в чате поручает ИИ-агенту найти и приобрести нужный товар с заданными параметрами. ИИ-агент в разговоре уточняет у пользователя задание, составляет описание товара и на его основе формирует запрос к поисковой системе... а затем ищет товар в базах данных поставщиков. Как это реализовать

https://habr.com/ru/articles/893536/

#LLM #UUIDv7 #ииагент #RAG #MCP #бд #schemaorg #ключ #сниппет

Show HN: Generate Version 7 UUID's for a Timestamp
https://uuidv7.org/
#ycombinator #uuidv7 #uuid #generator #date_based_uuid #time_based_uuid #version7 #online_tools