pauloxnet

Joined 8 years ago

Karma
1,620
Submissions
217
Member since
Jan 6
https://www.paulox.net

- Python developer

- Django contributor

- Conference speaker

- Remote worker

- GNU/Linux user

- Free Software advocate

--

View on Hacker News

Recent submissions

Comment · 10 months ago
A personal retrospective on organizing a small, standalone Django contributor sprint.

This is a follow-up written three months later, reflecting on what worked, what didn’t, and what kind of value emerged beyond pull requests and GitHub activity.

It’s about keeping things small, human-scale, and focused on being together, rather than optimizing for conference-style output.

Comment · 11 months ago
Thanks for pointing this out and for sharing the link.
Comment · 11 months ago
I’ve just updated the article with several clarifications and an additional section based on the feedback received yesterday. Thanks to everyone who contributed suggestions!
Comment · 11 months ago
Thanks for the comment. In the article I actually show both approaches: Python 3.14’s uuid.uuid7() first, mostly for completeness, and then the recommended one where PostgreSQL 18 generates the UUIDv7 itself using the native uuidv7() function. The DB-side version is already the default path I suggest for anything beyond a simple local setup.

Regarding the timestamp, a dedicated column generated by the database from uuid_extract_timestamp() can be very practical in Django. It is written at insert time by PostgreSQL, defined declaratively in the model with GeneratedField, and handled entirely by the ORM without relying on triggers. It also makes filtering, ordering or using the Django admin faster and simpler, since querying on a proper datetime field avoids extra annotations or computation on the UUID expression.

If you have a reference for UUIDv7 support in MSSQL I’d really appreciate it, ideally from the official documentation. I’m also curious to know from which version it is available and whether the current Django MSSQL backend exposes it already.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton