Re:Bye Sequence, Hello UUIDv7
by stepanhruda on Monday October 02, 2023 @09:21AM
(#37737717)
As I understood it, a big part of the premise of the post was that they see sequential storage (either in db or cache layer) as desirable
Re:Bye Sequence, Hello UUIDv7
by johncolanduoni on Monday October 02, 2023 @11:12AM
(#37739184)
What distributed databases shard on the low bits? How do they do something like a range query?
The closest I’ve ever heard of is sharding based on a hash (e.g. CockroachDB can do this on request[1]) but most distributed databases with strong consistency (Spanner descendants in particular) default to “doing it wrong”.
[1]: https://www.cockroachlabs.com/docs/stable/hash-sharded-index...
Fortunately, there's no rule that says you should shard your keys using the sequential part of the ID.