I insert a list of entities in the DB, say articles, for a user. Primary keys are UUIDs.
To sort the articles just as they were initially sent through the List, I tried to sort on
inserted_at. It doesn’t work because these records all have the same value for
inserted_at, as they were inserted at the same time.
I might have two options:
Use microseconds? If I insert that collection of articles, will the timestamp in
inserted_atbe guaranteed to have different microseconds?
Add an auto-incremented field if the microsecond precision would be a bad idea?