3 ms·
The ascending order of IDs though is a great property that is used in other contexts. I.e. for many of our workflow processes we want queries to return reverse
by hn_throwaway_99 3y ago
The ascending order of IDs though is a great property that is used in other contexts. I.e. for many of our workflow processes we want queries to return reverse chronological order, and "ORDER BY id DESC" is our most common sort. A v7 UUID as a primary key is still great for that, so you'd usually want to keep that property.