Hacker News Reader

It's too bad a number of managed Postgres services don't support UUIDv7 yet through supported extensions.

DigitalOcean and AWS RDS both support the https://www.postgresql.org/docs/16/uuid-ossp.html extension but it mentions v5 is the highest supported UUID version.

View on HN

You can generate the UUID in your application and insert it, UUIDv7 can be used in any UUID column in Postgres. UUIDv7 natively in Postgres are coming in v17: https://commitfest.postgresql.org/43/4388/.

There’s a pure pgsql implementation here which you can use:

https://github.com/kiwicopple/pg-extensions/tree/main/pg_idk...

Also since RDS supports trusted language extensions you can install it via dbdev:

https://database.dev/kiwicopple/pg_idkit

Thanks for the links

Reply on news.ycombinator.com