📝Lexorank

Lexorank is a system to store ordered items in a database that allows efficient reordering.

Each item is assigned a rank—a string. Ranks are sorted lexicographically to get items’ order.

When you need to reorder an item, you assign it a rank that is lexicographically between ranks of new neighboring items. For each item re-order, a single row needs to be modified in database.

Resources

Backlinks