3 ms·
I personally use: https://github.com/tvondra/sequential-uuids https://github.com/tvondra/sequential-uuids The time component resolution is configurable, and yo
by Tostino 6y ago
I personally use: https://github.com/tvondra/sequential-uuids https://github.com/tvondra/sequential-uuids
The time component resolution is configurable, and you can make it wrap around every so often, filling in gaps left by page splits, updates, deletes, etc.
- j-pb 6y agoNice! This is kinda what I had in mind, while writing that ammendum! Thanks for sharing :D
- Sytten 6y agoIts just a bit annoying because it is a C extension and that can't be used in most managed DB in the cloud.
- Tostino 6y agoI had to re-write the time based function from that extension in PL/PGSQL earlier in the week for someone on my team who couldn't work with the C extension: https://gist.github.com/Tostino/ca104bff40e704b6db70b9af492664ef https://gist.github.com/Tostino/ca104bff40e704b6db70b9af4926... This can be used in RDS, etc.