Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
da_chicken
72 days ago
|
parent
|
context
|
favorite
| on:
Exploring PostgreSQL 18's new UUIDv7 support
Are there really any performances benefits of UUIDv7 over UUIDv4 that should ever come up in the context of an HR system? Just how many job applicants are you tracking?
I don't understand why you considered UUIDv7 in the first place.
MikeNotThePope
72 days ago
[–]
You can sort records by ID, retrieve the last N records by ID, etc. It's just easier than using a timestamp.
Incipient
71 days ago
|
parent
[–]
The guaranteed lack of collision is a big one. I pretty much always add an updated column, and sqlalchemy essentially gives you both for free.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
I don't understand why you considered UUIDv7 in the first place.