I'm trying to work out how apps like this and trello calculate and store card poisition with as little overhead as possible.
It seems obvious that every time you move a card to a column, you recalculate the order of every card, however that has overhead because you have to send the new order of every card to the server.
Is there a more efficient way to solve this problem? It seems to me it would be more efficient to assign a position value for only the card you are moving relative to those before and after it.
I'm sure trello has solved this