Not directly related to 8base, but I’m curious about others’ thought on user-ordered items. i.e. displaying rows in order of drag-and-drop.
I’ve seen implementations use numbering (0, 100, 200), insert 150, and deferred or manual normalization. It can also be done with strings (a, ab, c). You can use ‘nextId’ and build a linked list, but that seems like a penalty on performance for the query, being recursive? Another approach is using a separate table to store the ordering (using “Allow Multiple” mahybe?), but it’s not easily queryable
Another option is to sort on the client, using one of the techniques above to simply store the relations. If there are hundreds, or even thousands, it’s possible. But if there are 100,000 paged items, it must come from the query.