getmusicbee.com

Support => Questions => Topic started by: wrwetzel on August 04, 2015, 04:59:17 PM

Title: Database Question
Post by: wrwetzel on August 04, 2015, 04:59:17 PM

I would like to access the MusicBee library database file, MusicBeeLibrary.mbl, outside the scope of the MusicBee application to look at some of the statistics of my library. Among other things I would like to find the most common titles, artists, etc., look for titles, artists, albums, etc., with spelling errors, and more.

Is the database file in a form that is supported by one of the common database applications, e.g. Sqlite, MySql, Postgress, etc.? A quick look did not reveal anything distinctive to me and I was unable to view it with Sqlite tools.

Thanks,
Bill

Title: Re: Database Question
Post by: psychoadept on August 04, 2015, 05:20:11 PM

The Additional Tagging & Reporting tools plugin should help you there.  Messing with the database directly is a bad idea.

http://musicbee.wikia.com/wiki/Additional_Tagging_and_Reporting_Tools

Title: Re: Database Question
Post by: wrwetzel on August 04, 2015, 08:05:43 PM

Should not be a problem as long as I open it read-only, which is all I need as I have no desire to change it.
Bill

Quote from: psychoadept on August 04, 2015, 05:20:11 PM

The Additional Tagging & Reporting tools plugin should help you there.  Messing with the database directly is a bad idea.

http://musicbee.wikia.com/wiki/Additional_Tagging_and_Reporting_Tools

Title: Re: Database Question
Post by: psychoadept on August 04, 2015, 08:39:56 PM

I really think the plugin is your best bet; it has very comprehensive tools and good support.  Steven has not offered any suggestions on accessing the database in the past.

Title: Re: Database Question
Post by: phred on August 04, 2015, 09:42:59 PM

I'd suggest copying the .mbl to another directory before you open it.  That way you can copy it back should something go wrong.  Once it's gone, it's gone.

Title: Re: Database Question
Post by: Steven on August 04, 2015, 09:54:45 PM

i confirm the darabase is only intended to be accessible via exporting an iTunes xml file, the API or the reporting tools plugin

Title: Re: Database Question
Post by: wrwetzel on August 06, 2015, 04:10:05 PM

Thanks to all for your comments. I have looked at the Additional Tagging Tools plugin and it appears that it will satisfy my needs. My original question still remains unanswered, however:

    Is the database file in a form that is supported by one of the common database applications, e.g. Sqlite, MySql, Postgress, etc.?

Thanks,
Bill