by Schmidtze » Fri Sep 22, 2017 5:09 am
Hi,
I just moved from iTunes to MM some days before. It seems that MM works very well, my library contains about 60.000 files and MM handles it without any problems by now. So I'm very happy with it - except the lacking of special sort fields for artists
As I'm a developer for myself, I always like to take a look into the database for myself, for example to execute some statistics queries on my data etc. So I was very happy that MM uses an ordinary SQLite database which understands something like this "select artist, count(id) from songs group by artist order by count(id)". BUT: Unfortunately MM uses a special collation functionalety, so managing it with my favorite SQLite managing tool "SQLite Expert" gave errors when sorting and grouping. I asked the developer about it and he now built in an additional option called "auto install generic collations". With this option enabled, it works perfect. When starting the application it still shows an error like "unknown tokenizer: mm SQL Statement..." but after that it can be used without any problems.
I found some messages about this problem, also in this forum, and also in the bug tracker of MM. Maybe SQL Expert is an alternative for you if you want to manage the database of MM on your own.
Best regards
Schmidtze
Hi,
I just moved from iTunes to MM some days before. It seems that MM works very well, my library contains about 60.000 files and MM handles it without any problems by now. So I'm very happy with it - except the lacking of special sort fields for artists :wink:
As I'm a developer for myself, I always like to take a look into the database for myself, for example to execute some statistics queries on my data etc. So I was very happy that MM uses an ordinary SQLite database which understands something like this "select artist, count(id) from songs group by artist order by count(id)". BUT: Unfortunately MM uses a special collation functionalety, so managing it with my favorite SQLite managing tool "SQLite Expert" gave errors when sorting and grouping. I asked the developer about it and he now built in an additional option called "auto install generic collations". With this option enabled, it works perfect. When starting the application it still shows an error like "unknown tokenizer: mm SQL Statement..." but after that it can be used without any problems.
I found some messages about this problem, also in this forum, and also in the bug tracker of MM. Maybe SQL Expert is an alternative for you if you want to manage the database of MM on your own.
Best regards
Schmidtze