3 Commits

Author	SHA1	Message	Date
Deluan Quintão	5c3568f758	fix(ui): make playlist name sorting case-insensitive (#4845) ... * fix: make playlist name sorting case-insensitive Add collation NOCASE to playlist.name column to ensure case-insensitive sorting, matching the behavior of other tables like radio and user. This fixes the issue where uppercase playlist names would appear before lowercase names regardless of alphabetical order. The migration recreates the playlist table with the proper collation and recreates all associated indexes. Corresponding collation tests are added to verify the fix persists through future migrations. * fix: add default sorting to playlist names Signed-off-by: Deluan <deluan@navidrome.org> --------- Signed-off-by: Deluan <deluan@navidrome.org>	2026-01-05 19:05:11 -05:00
Deluan	3982ba7258	revert: separation of write and read DBs ... Signed-off-by: Deluan <deluan@navidrome.org>	2024-11-19 18:41:50 -05:00
Deluan Quintão	fcb5e1b806	fix(server): fix case-insensitive sort order and add indexes to improve performance (#3425) ... * refactor(server): better sort mappings * refactor(server): simplify GetIndex * fix: recreate tables and indexes using proper collation Also add tests to ensure proper collation * chore: remove unused method * fix: sort expressions * fix: lint errors * fix: cleanup	2024-10-26 14:06:34 -04:00