I'm a huge fan of navidrome, and thus spent some time reading its source code, and discussing with Deluan about its data model, making this list of weird edge-cases as we went.