Sort Crates and Playlists using localeAwareCompare

[Daniel Schürmann]

Ä should sort near A for German users.
This is already implemented for Track sorting and should be used for every user data sorting.

The issue was discussed here:
https://github.com/mixxxdj/mixxx/pull/1034

[Uwe Klotz (uklotzde-deactivatedaccount)]

...and the sorting should be case-insensitive ;)

[Uwe Klotz (uklotzde-deactivatedaccount)]

I will implement this for crates after I'm done with the refactoring of the DAO.

[Uwe Klotz (uklotzde-deactivatedaccount)]

Very easy to implement when reusing and extending the custom "localeAwareCompare" collation for SQLite that is already registered by Mixxx. But we also need to check if all table models/views are sorting correctly, i.e. case insensitive and locale aware. Maybe we need to introduce QSortFilterProxyModel.

[Daniel Schürmann (daschuer)]

Interesting, I was not aware of this QSortFilterProxyModel class. It looks like using it moves the sorting and filtering from SQLite to the Qt domain. That sounds like a big refactoring :-/

Do you have an idea if this has a performance impact?

The current caching/sorting solution is hard to maintain and understand anyway. It took me quite long to realise that the displayed data is a mixture of three sources, direct sqlite calls, BaseTrackCache cache and recentTracksCache.

Without knowing it exactly, I have the feeling that it should be possible to rely on the performance features of SQLite without all our extra caching. Unfortunately we cannot have test data to verify this without a working solution.

[RJ Skerry-Ryan (rryan)]

I would be cautious with using QSortFilterProxyModel. We used to use this in Mixxx in the 2008 time-frame and it introduced a big performance penalty over using SQLite to do sorting.

[Uwe Klotz (uklotzde-deactivatedaccount)]

https://github.com/mixxxdj/mixxx/pull/1099

[Swiftb0y (swiftb0y)]

Mixxx now uses GitHub for bug tracking. This bug has been migrated to:
https://github.com/mixxxdj/mixxx/issues/8675