On: UUIDv7: Timestamps aren’t time-ordered and other oddities

[saagarjha]

Yes, which means that you should probably be able to provide your timestamp to the database so it can use it for optimizing its index, rather than trying to shove it in your ID

[debazel → saagarjha]

If you did that you would also have to provide the timestamp every time you wanted to look up an ID, and now we're back to UUIDv7 again.

[saagarjha → debazel]

Sure but at least you are being honest about it. For what it's worth the database can handle this internally without you needing to hand this back but if you have a bad one then yes you should probably have it give you back a location hint that you use for future queries

[ndriscoll → saagarjha]

How would it internally sort your index by (timestamp, ID) without you later having to provide the timestamp to locate the ID?