SQLite database of MM and special collation functionalety

Discussion about anything that might be of interest to MediaMonkey users.

Moderator: Gurus

SQLite database of MM and special collation functionalety

Postby 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 :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
Schmidtze
 
Posts: 1
Joined: Fri Sep 22, 2017 4:45 am

Re: SQLite database of MM and special collation functionalet

Postby Barry4679 » Sat Oct 14, 2017 11:33 pm

Thanks Schmidtze,

I can confirm that it seems to work well. Also works well when MM is an attached table.

The "auto install generic collations" option is at Tools|Options|Data.
Barry4679
 
Posts: 246
Joined: Fri Sep 11, 2009 8:07 am
Location: Australia

Re: SQLite database of MM and special collation functionalet

Postby Barry4679 » Mon Oct 16, 2017 7:46 pm

One other thing to add. When you open the MM database using SQLite Expert you many get the following error message. This seems to be because MM have not distributed something to customers. As it only affects the one table mentioned in the error message, you can ignore this error message.

https://www.dropbox.com/s/so3lm0qhy77738g/MMExpertError.png?dl=0
Barry4679
 
Posts: 246
Joined: Fri Sep 11, 2009 8:07 am
Location: Australia


Return to News and Other Stuff

Who is online

Users browsing this forum: No registered users and 13 guests