Two Backend Approaches for Drag‑and‑Drop Sorting: Array vs. Doubly Linked List
The article compares two backend implementations for drag‑and‑drop ordering—using a simple position column (array model) and a doubly linked list with prev_id and sibling_id—detailing their MySQL schemas, update logic, performance trade‑offs, and practical considerations such as pagination and locking.