I'm trying to store/represent a list in a database.
I need this list to be 'fully persisted', however. I don't want it to be stored as a 'bag of items', but rather an ordered group.
Other people have certainly done what I'm trying. The linked post indeed has some clever solutions.
Anyone have a name for this concept / pattern, though? Fully persisted list?
I'm trying to find the best solution to it for my case, but I'm being slowed down because it's hard to search for something so vague.
Also if anyone has any other links relevant to the idea, I'd greatly appreciate it - I've had trouble finding relevant info.
EDIT:
List of relevant questions for reference
To Gordon's point in the comments, within the database the data is, by definition, unordered.
With that in mind, the concept that you're trying to put a name to is most often referred to as either "display order" or "presentation order", and the challenge is maintaining that column in the data set during (or immediately following) CRUD operations.