4 ms·
Simple solution: Don't use `unique`. (Let's assume that your db is very fast, and let your app update all needed positions on save)
by udioron 9y ago
Simple solution: Don't use `unique`.
(Let's assume that your db is very fast, and let your app update all needed positions on save)
- OldSchoolJohnny 9y agoYes! I'm reading through all this discussion and thinking "why are these people so bent on overthinking such a simple concept"? Also using text as the sort order solves most of the issues people are bringing up.
- hobs 9y agoPretty much every implementation of arbitrary sort order I have seen uses varchar for this very reason, and requires none of the cleverness in the article.