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