For a pet project of mine, I'm experimenting with alternatives to the classic SERIAL primary keys which are simple, local and performant. However, ...
For further actions, you may consider blocking this person and/or reporting abuse
There's a discussion going on to make UUIDv7 (or similar) part of the PostgreSQL core itself. Depending on when the formal standard is finalized, this feature might even make it to PostgreSQL 17 later this year. 🎉
Here's a little followup: In case you're on Mac or Linux and would like to experiment with UUIDv7 locally, you can use my Homebrew formula to install the pg_uuidv7 extension it on your machine.
Nice post. Could consider adding that you can also generate UUIDv7 directly in SQL, see: gist.github.com/kjmph/5bd772b2c2df...