5 ms·
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
by nickjj 3y ago
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 https://www.postgresql.org/docs/16/uuid-ossp.html extension but it mentions v5 is the highest supported UUID version.
- sondr3 3y agoYou 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/ https://commitfest.postgresql.org/43/4388/.
- kiwicopple 3y agoThere’s a pure pgsql implementation here which you can use: https://github.com/kiwicopple/pg-extensions/tree/main/pg_idkit 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 https://database.dev/kiwicopple/pg_idkit
- canadiantim 3y agoThanks for the links