User-defined Order in SQL | Hacker News

Having run into this problem a few times now, Approach 1 is unfortunately best. Two reasons:(1) If updates fail, you don't get a resulting broken state (2) The size of the lists is not that large (<50), so the extra writes are not that expensive. Essentially, with any variation on fractional updates (where only 1-2 rows are updated per list update), the client is sending to the server "move item a