Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[roald.andresen]

Hi
First of all.  I apologise if this is a question that has been asked one or more times before (even worse,if I have asked it before), and if I placed it in the wrong forum.

On the top of my wish list for the JRiver MediaPlayer is an SQL and/or jdbc interface to the library database - a read-only interface would be enough.  The database format seems very much to be proprietary and is probably a company secret.  If I'm wrong (about the secret part), is there (or will there ever be) a documentation of it?

With kind regards,
Roald Andresen

[RoderickGI]

Check out MCWS in the Dev Wiki. https://wiki.jriver.com/index.php/DevZone

There are tools that can get data out of MC. MCUtils and "Swag Of Tools" for example. Search the forum for them. But I suspect you are running on Linux, while those are Windows tool.

You can just copy data from Views in MC, and paste into an external application.


What are you actually trying to do?

[guer_j]

You can download the your whole library data as XML.
Something like this:

https://192.168.1.x:52199/MCWS/v1/Library/Get?Settings=0


Then, if you have access to a SQLServer for example  (there might be other db engines that lets you do this too) you could use that XML and query using the standard query language.


https://docs.microsoft.com/en-us/sql/t-sql/xml/query-method-xml-data-type?view=sql-server-ver15


But honestly this is not a very efficient use of sql. JRiver query engine is pretty great, no need to reinvent the wheel there.

[zxsix]

I've never used it, but another user created a plugin to link the MC database to Microsoft SQL.
It's read/write.

https://yabb.jriver.com/interact/index.php/topic,56405.msg768996.html#msg768996