4 ms·
> colocating database data by time, providing "sooner than" comparisons. If you need to perform date/time related operations, use date/time related data types,
by sedatk 2y ago
> colocating database data by time, providing "sooner than" comparisons.
If you need to perform date/time related operations, use date/time related data types, not an unrelated type that happens to have some arbitrary timestamp embedded in its binary layout.
> Integers are monotonic but can't be distributed like UUIDs.
Yes, use UUIDs if you need distribution, use integers if you need monotonicity. If you need "monotonic and distributed", you need an external authority for proper distribution of those IDs. Then, an integer would still work.
- paulddraper 2y ago> use date/time...not...timestamp :/