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

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

It 🤯 me how clever #UUID7 decouples creation time from the local file metadata when saved, and/or a db-column/key.

Reading https://uuid7.com/ I am beginning to see how using it will simplify so much of the idea I'm working on. Both for single use and scale nicely to all the more complexed distributed collaboration.

It means I can probably use just one UUID7 instead of the current design with multiple data pieces and lots of complex code/logic.

Can it really be so elegant 🤔

- https://discuss.python.org/t/python-3-14-0-final-is-here/104210 (Python 3.14.0 (final) is here!)

- https://docs.python.org/3.14/whatsnew/3.14.html (What’s new in Python 3.14 by Adam Turner and Hugo van Kemenade)

- https://docs.python.org/3.14/whatsnew/changelog.html#changelog (Python 3.14 Changelog)

- https://astral.sh/blog/python-3.14 (Astral ready for Python 3.14)

```
uv self update
uv python upgrade 3.14
uvx [email protected]
uvx [email protected]
```

#Annotations

- https://docs.python.org/3/whatsnew/3.14.html#pep-649-pep-749-deferred-evaluation-of-annotations
- https://discuss.python.org/t/python-3-14-0-final-is-here/104210#:~:text=the%20evaluation%20of%20annotations%20is%20now%20deferred

Instead, annotations are stored in special-purpose annotate functions and **evaluated
only when necessary** (except if from __future__ import annotations is used).

# PEP 768 Python 3.14 **Safe external debugger interface, a zero-overhead external debugger interface for CPython

- https://docs.python.org/3.14/whatsnew/3.14.html#pep-768-safe-external-debugger-interface
- https://discuss.python.org/t/python-3-14-0-final-is-here/104210#:~:text=A%20zero%2Doverhead%20external%20debugger%20interface%20for%20CPython

Python 3.14 introduces a zero-overhead debugging interface that allows debuggers and profilers to safely attach to running Python processes without stopping or restarting them.

# RFC9562 Python 3.14 **UUID versions 6-8 are now supported by the uuid module**

- https://docs.python.org/3/whatsnew/3.14.html#uuid
- https://discuss.python.org/t/python-3-14-0-final-is-here/104210#:~:text=UUID%20versions%206%2D8%20are%20now%20supported%20by%20the%20uuid%20module

# zstandard

- https://peps.python.org/pep-0784/ (Adding Zstandard to the standard library)
- https://docs.python.org/3/whatsnew/3.14.html#whatsnew314-zstandard
- https://discuss.python.org/t/python-3-14-0-final-is-here/104210#:~:text=compression.zstd%20providing%20support%20for%20the%20zstandard%20compression%20algorithm.

# A new command line interface with asyncio introspection capabilities: python -m asyncio ps PID

- https://docs.python.org/3/whatsnew/3.14.html#asyncio-introspection-capabilities
- https://discuss.python.org/t/python-3-14-0-final-is-here/104210#:~:text=inspect%20running%20Python%20processes

# Multiple interpreters in the standard library

- https://peps.python.org/pep-0734/ (Multiple Interpreters in the Stdlib)
- https://docs.python.org/3.14/whatsnew/3.14.html#pep-734-multiple-interpreters-in-the-standard-library
- https://discuss.python.org/t/python-3-14-0-final-is-here/104210#:~:text=Multiple%20interpreters%20in%20the%20stdlib

- https://gdevops.frama.io/python/versions/3.14.0/3.14.0.html

# Python #Python314 #TemplateString #ZStandard #RemoteDebugging #MultipleInterpreters #FreeThreaded #UUID7 #asyncio #parallelism #CSP #ActorModel