Post #3727501
2026-07-09 06:57 UTC
#Django tip 💚 if you use UUID7 for primary keys, why not use it for date range filters? It's really efficient 🔥 #tip
Q(uuid__gte=UUID7(shift=Value(start_datetime) - Now()))
Q(uuid__lte=UUID7(shift=Value(end_datetime) - Now()))
Replies (1)
-
@ngnpope@fosstodon.org 2026-07-09 07:34
@felixxm@fosstodon.org PostgreSQL also provides a `uuid_extract_timestamp` function so it should be possible to write a transform allowing us to do `Q(uuid__timestamp__gte=midnight)`